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.
V0289:
The specification states the following:
-
Subclause 6.10, "<window function>": <nth value function> ::= NTH_VALUE <left paren> <value expression> <comma> <nth row> <right paren> [ <from first or last> ] [ <null treatment> ] ... Conformance Rules Without Feature T618, "NTH_VALUE function", conforming SQL language shall not contain <nth value function>.
Microsoft SQL Server 2008 R2 varies as follows:
This feature is absent from the [ISO/IEC9075-2:2008] standard.
Microsoft SQL Server 2012 varies as follows:
Transact-SQL does not support this feature.