18-rank.sql

来自「SQL Server 2005基础教程一书的源代码.」· SQL 代码 · 共 8 行

USE AdventureWorks
GO
SELECT ROW_NUMBER() OVER(ORDER BY Department) AS RowNum,
        RANK() OVER(ORDER BY Department) AS Ranking,
        FirstName + ' ' + LastName AS Employee, Department 
  FROM HumanResources.vEmployeeDepartment
 ORDER BY RowNum