Creating a Table in SQL Server
The table looks as in the following:
NTILE() Function
Divides 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 (int_exp) OVER ([<partition_by_clause>]<order_by_clause>)
Example
SELECT *, NTILE(5) OVER (ORDER BY User_Id) AS Ntile_Number
FROM userdetail
OUTPUT
Join the conversation! Your thoughts help the community grow.