select top pagesize * from userswhere id not in(select top (pageindex-1)*pagesize id from users order by id)
select top pagesize * from userswhere id >(select MAX(id) from(select top (pageindex-1)*pagesize id from users order by id)a)
--只适用于sql2005及以版本用法select * from(select bh=ROW_NUMBER() over(order by id),* from users)awhere bh between (pageindex-1)*pagesize+1 and pageindex*pagesize
