sql server实现分页的方法实例分析

declare @index int,@num int
set @index = 1--当前页
set @num = 2--单页包含的行数
--分页1
select  (@num) 
from ppohd
where doode not in
(
  select  (@num  (@index -1)) doode
  from ppohd
  order by doode
)
order by doode
--分页2
select  (@num) 
from ppohd
where doode >=
(
  select max(doode)
  from
  (
    select  (@num  (@index - 1) + 1) doode
    from ppohd
    order by doode
  ) as tb
)
--分页3
select  (@num) 
from
(
  select ppohd.doode as 'mydoode',row_number() over (order by doode) as sno,
  from ppohd
) as tb
where tb.sno >= @num  (@index - 1) + 1
--分页4
select 
from
(
  select ppohd.doode as 'mydoode', row_number() over(order by doode) as sno,
  from ppohd
) as tb
where tb.sno between (@num  (@index - 1) + 1) and (@num  @index)