20-ntile.sql

SQL Server 2005基础教程一书的源代码.

USE AdventureWorks
GO
SELECT NTILE(10) OVER(ORDER BY Department) AS NTile,
        FirstName + ' ' + LastName, Department 
  FROM HumanResources.vEmployeeDepartment