Share via


2.1.2.187 T052, MAX and MIN for row types

V0223:

The [ISO/IEC9075-2:2008] specification states the following:

 Subclause 6.26, "<value expression>":
  
 <value expression> ::=
 <common value expression>
 | <boolean value expression>
 | <row value expression>
  
 Subclause 10.9, "<aggregate function>":
  
 <computational operation> ::=
 AVG
 | MAX
 | MIN
 | SUM
 | EVERY
 | ANY
 | SOME
 | COUNT
 | STDDEV_POP
 | STDDEV_SAMP
 | VAR_SAMP
 | VAR_POP
 | COLLECT
 | FUSION
 | INTERSECTION
  
 ...
  
 Conformance Rules
  
 Without Feature T052, "MAX and MIN for row types", conforming SQL language shall not contain a <computational operation> that immediately contains MAX or MIN in which the declared type of the <value expression> is a row type.
  
 NOTE — If DISTINCT is specified, then the Conformance Rules of Subclause 9.10, "Grouping operations", also apply. If MAX or MIN is specified, then the Conformance Rules of Subclause 9.12, "Ordering operations", also apply.
  
 Subclause 9.10, "Grouping operations":
  
 Conformance Rules
  
 Without Feature S024, "Enhanced structured types", in conforming SQL language, the declared type of an operand of a grouping operation shall not be ST-ordered.
  
 Subclause 9.12, "Ordering operations":
  
 Conformance Rules
  
 Without Feature S024, "Enhanced structured types", in conforming SQL language, the declared type of an operand of an ordering operation shall not be ST-ordered.

Microsoft SQL Server 2008 R2 varies as follows:

Transact-SQL does not support this feature.

Microsoft SQL Server 2012 varies as follows:

This feature is absent in the [ISO/IEC9075-02:2011] standard.