代码
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 ;
( SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER ( order by OrderDate) as RowNumber
FROM Sales.SalesOrderHeader )
SELECT *
FROM OrderedOrders
WHERE RowNumber between 50 and 60 ;
with可以给结果集重命个名;
2005新增加的函数ROW_NUMBER()可以计算行数,再分页
select
*
from
(
select
*
,row_number()
over
(
order
by
english)
as
rownumber
from stu_score) as c where rownumber between 50 and 100
from stu_score) as c where rownumber between 50 and 100
