16-row_number.sql

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

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