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]

See Also#