Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.