NTILE#
Distributes the rows in an ordered partition into a specified number of groups. The groups are numbered, starting at one. For each row, NTILE returns the number of the group to which the row belongs.
Syntax#
NTILE (integer_expression)
OVER ( [ <partition_by_clause> ] < order_by_clause > )
Arguments#
index
Is a positive integer constant expression that specifies the number of groups into which each partition must be divided. index can be of type int, or bigint.
Return types#
float
Example#
SELECT NTILE(5) OVER(PARTITION BY [IntColumn] ORDER BY [IntColumn]) AS [ntiled]
FROM [IntTable]