总结 SQL SERVER , row_number()
总结SQL SERVER , row_number()http://msdn.microsoft.com/zh-cn/library/ms186734
对集合进行排序编号，并选取编号符合条件的结果
1.
USE AdventureWorks2008R2;
GO
WITH OrderedOrders AS
(
SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'
FROM Sales.SalesOrderHeader
)
SELECT *
FROM OrderedOrders
WHERE RowNumber BETWEEN 50 AND 60;
2.
select * from
(
select * , number = row_number() over(order by> ) m where number = 你指定的数值.
3..function
页:
[1]