2.1.2.248 T611, Elementary OLAP operations

V0284:

The specification states the following:

 Subclause 6.10, "<window function>":
  
 <window function> ::=
 <window function type> OVER <window name or specification>
  
 <window function type> ::=
 <rank function type> <left paren> <right paren>
 | ROW_NUMBER <left paren> <right paren>
 | <aggregate function>
  
 <rank function type> ::=
 RANK
 | DENSE_RANK
 | PERCENT_RANK
 | CUME_DIST
  
 <window name or specification> ::=
 <window name>
 | <in-line window specification>
  
 <in-line window specification> ::=
 <window specification>
  
 Conformance Rules
  
 1) Without Feature T611, "Elementary OLAP operations", conforming SQL language shall not contain a <window function>.
  
 Subclause 7.11, "<window clause>":
  
 <window specification> ::=
 <left paren> <window specification details> <right paren>
  
 <window specification details> ::=
 [ <existing window name> ]
 [ <window partition clause> ]
 [ <window order clause> ]
 [ <window frame clause> ]
  
 ...
  
 Conformance Rules
  
 1) Without Feature T611, "Elementary OLAP operations", conforming SQL language shall not contain a <window specification>.
  
 Subclause 10.10, "<sort specification list>":
  
 <sort specification> ::=
 <sort key> [ <ordering specification> ] [ <null ordering> ]
  
 ...
  
 <null ordering> ::=
 NULLS FIRST
 | NULLS LAST
  
 ...
  
 Conformance Rules
  
 1) Without Feature T611, "Elementary OLAP operations", conforming SQL language shall not contain a <null ordering>.
  
 NOTE — The Conformance Rules of Subclause 9.14, "Ordering operations", also apply.
  
 Subclause 9.14, "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 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL partially supports this feature. Transact-SQL does not support null ordering or all aggregate functions.