19-denserank.sql

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

USE AdventureWorks
GO
SELECT ROW_NUMBER() OVER(ORDER BY Department) AS RowNum,
        DENSE_RANK() OVER(ORDER BY Department) AS Ranking,
        CONVERT(varchar(25),FirstName + ' ' + LastName), Department 
  FROM HumanResources.vEmployeeDepartment
 ORDER BY RowNum