Share via


2.1.2.253 T618, NTH_VALUE function

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.