sql 分页查询二

引用:http://wenku.baidu.com/view/b8f42f3c376baf1ffc4fad38.html

适用于sql server2000/2005

select top 页大小*

from table

where id not in(

  select top 页大小*(页数-1) id from table order by id

)

order by id

posted @ 2012-02-22 11:19  镇水古月  阅读(103)  评论(0编辑  收藏  举报