主题：Row_Number函数能否用两列作为排序列

sql server 2008可以，其它没试过

USE AdventureWorks2008;
GO

WITH OrderedOrders AS
(
    SEL ECT *,
    ROW_NUMBER() OVER (ORDER BY OrderDate desc,SalesOrderNumber desc) AS 'RowNumber'
    FROM Sales.SalesOrderHeader
)
SEL ECT *
FROM OrderedOrders
WHERE RowNumber BETWEEN 30 AND 60;