17-rownum-2.sql

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

USE AdventureWorks
GO
SELECT ROW_NUMBER() 
  OVER(PARTITION BY SUBSTRING(LastName,1,1) 
  ORDER BY LastName) AS RowNum, FirstName + ' ' + LastName 
  FROM HumanResources.vEmployee  
 WHERE JobTitle = 'Production Technician - WC60'
 ORDER BY LastName