Share via


2.1.2.251 T614, NTILE function

V0287:

The specification states the following:

 Subclause 6.10, "<window function>":
  
 <ntile function> ::=
 NTILE <left paren> <number of tiles> <right paren>
  
 ...
  
 Conformance Rules
  
 Without Feature T614, "NTILE function", conforming SQL language shall not contain <ntile 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 partially supports this feature. The parameters and exact functionality of the Transact-SQL NTILE function differ.