sql2005利用row_numer实现分页的两种常用方式
代码如下:
declare @pagenumber int
declare @pagesize int
set @pagenumber=2
set @pagesize=20
--利用between
select *
from
(
select
row_number() over (order by source_ip,id) as row_num,
* from tb) as page_table
where row_num between (@pagenumber - 1) * @pagesize + 1 and @pagenumber * @pagesize
--利用top方式
select top 20 *
from
(
select
row_number() over (order by source_ip,id) as row_num,
* from tb
) as page_table
where row_num > (@pagenumber - 1) * @pagesize
order by row_num
[/code]