SELECT EmployeeId, FullName EmployeeName, DepartmentId, JobTitle, ROW_NUMBER() OVER (PARTITION BY DepartmentId ORDERBY JobTitle ) RowNum,--序号 RANK() OVER (PARTITION BY DepartmentId ORDERBY JobTitle) Rank,--等级1,1,3 DENSE_RANK() OVER (PARTITION BY DepartmentId ORDERBY JobTitle ) DenseRank,--等级1,1,2 NTILE(2) OVER (PARTITION BY DepartmentId ORDERBY JobTitle ) Ntile--将每个Department的纪录平均分成2组,每组有相同的NTILE值 FROM Employee ORDERBY DepartmentId