--A:数据条数 B:页码
select top A * from Table
where uid not in(select top ((B-1)*A) uid from Table)
列如:
每页显示5条数据 第一页查询语句如下
select top 5 * from adminInfo
where uid not in(select top ((1-1)*5) uid from adminInfo)
第二页
select top 5 * from adminInfo
where uid not in(select top ((2-1)*5) uid from adminInfo)