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   

posted @ 2011-11-16 17:21  左正  阅读(197)  评论(0编辑  收藏  举报