SqlServer 的几种分页方式

方式一：
select top 200 * from view_OrganResource
where  1=1 and OrganID = 57 and
(OrderID not in(select top 1000 OrderID from tb_OrganResource
where  1=1 and  OrganID = 57 order by uploadtime desc))
order by uploadtime desc --5858 1980
方式二：
select top 200 * from
view_OrganResource where  organid=57 and
uploadtime  <
(
    select min(uploadtime)
    from
    (
    select top 1000 uploadtime from view_OrganResource where organid=57 order by uploadtime desc
    ) a
)
order by uploadtime desc
方式三：
SELECT  ROW_NUMBER() OVER(ORDER BY orderid DESC) AS 'rnum',*
from view_OrganResource
WHERE 1=1 and rnum >1 and rnum < 1000
SELECT TOP 200 * from (SELECT
    ROW_NUMBER() OVER (ORDER BY  uploadtime desc) AS RowNumber,
    *
 from
    dbo.view_OrganResource) _myResults
 WHERE
    RowNumber > 1000
方式四：
SELECT * from (SELECT
    ROW_NUMBER() OVER (ORDER BY uploadtime desc) AS RowNumber,
    *
 from
    dbo.view_OrganResource) _myResults
 WHERE
    RowNumber between 1000 and 1200
go
方式五：
 WITH OrderedResults AS
 (SELECT *, ROW_NUMBER() OVER (order by uploadtime desc) as RowNumber from dbo.view_OrganResource)
 SELECT *
 from OrderedResults
WHERE RowNumber between 1001 and 1200
方式六：
BEGIN
                DECLARE @PageLowerBound int
                DECLARE @PageUpperBound int
                
                -- Set the page bounds
&n