MS SQLSERVER2000实现分页伪代码

select top pagesiz a.*

from tableName a.id not in

(select top pagesize*(pageindex-1) b.id

from tableName b order by b.id asc)

posted @ 2013-03-08 09:40  haikuang  阅读(109)  评论(0)    收藏  举报