select top pagesize * from users
where id not in(select top (pageindex-1)*pagesize id from users order by id)
select top pagesize * from users
where 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)a
where bh between (pageindex-1)*pagesize+1 and pageindex*pagesize