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.
V0110
The specification states the following:
-
Subclause 10.9, "<aggregate function>": <aggregate function> ::= COUNT <left paren> <asterisk> <right paren> [ <filter clause> ] | <general set function> [ <filter clause> ] | <binary set function> [ <filter clause> ] | <ordered set function> [ <filter clause> ] | <array aggregate function> [ <filter clause> ] <general set function> ::= <set function type> <left paren> [ <set quantifier> ] <value expression> <right paren> ... <binary set function> ::= <binary set function type> <left paren> <dependent variable expression> <comma> <independent variable expression> <right paren> ... <dependent variable expression> ::= <numeric value expression> <independent variable expression> ::= <numeric value expression> ... <hypothetical set function value expression list> ::= <value expression> [ { <comma> <value expression> }... ] <inverse distribution function> ::= <inverse distribution function type> <left paren> <inverse distribution function argument> <right paren> <within group specification> <inverse distribution function argument> ::= <numeric value expression> <inverse distribution function type> ::= PERCENTILE_CONT | PERCENTILE_DISC ... Conformance Rules Without Feature F442, "Mixed column references in set functions", conforming SQL language shall not contain a <hypothetical set function value expression list> or a <sort specification list> that simply contains a <value expression> that contains more than one column reference, one of which is an outer reference. Without Feature F442, "Mixed column references in set functions", conforming SQL language shall not contain an <inverse distribution function> that contains an <inverse distribution function argument> or a <sort specification> that contains more than one column reference, one of which is an outer reference. Without Feature F442, "Mixed column references in set functions", conforming SQL language shall not contain an <aggregate function> that contains a <general set function> whose simply contained <value expression> contains more than one column reference, one of which is an outer reference. Without Feature F442, "Mixed column references in set functions", conforming SQL language shall not contain an <aggregate function> that contains a <binary set function> whose simply contained <dependent variable expression> or <independent variable expression> contains more than one column reference, one of which is an outer reference. Subclause 10.10, "<sort specification list>": <sort specification list> ::= <sort specification> [ { <comma> <sort specification> }... ] <sort specification> ::= <sort key> [ <ordering specification> ] [ <null ordering> ] <sort key> ::= <value expression> <ordering specification> ::= ASC | DESC <null ordering> ::= NULLS FIRST | NULLS LAST
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.