NTILE (SQL)
A window function that splits the row within the specified window frame into num-groups number of groups that each have a roughly equal number of elements.
Synopsis
NTILE(num-groups)
Description
NTILE splits up the rows in the window frame into num-groups groups such that each group contains about the same number of elements. Each group is identified by a number, starting from one.
Arguments
num-groups
A number that specifies how many groups to split the rows into.
Examples
The following example splits up employees within each department into four groups based on their salaries:
SELECT NTILE(4) OVER (PARTITION BY Department ORDER BY Salary) FROM Company.Employee
