总结 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 id) from table
) m where number = 你指定的数值.

 

3.[dbo].[GetShouldSwichTime]  function