Top Categories
In this video we will discuss NTILE function in SQL Server NTILE function
1. Introduced in SQL Server 2005
2. ORDER BY Clause is required
3. PARTITION BY clause is optional
4. Distributes the rows into a specified number of groups
5. If the number of rows is not divi
In this video we will discuss NTILE function in SQL Server NTILE function
1. Introduced in SQL Server 2005
2. ORDER BY Clause is required
3. PARTITION BY clause is optional
4. Distributes the rows into a specified number of groups
5. If the number of rows is not divisible by number of groups, you may have groups of two different sizes.
6. Larger groups come before smaller groups
