Select Top 10 ID From [tablename] where id not in (Select top 150 id from [tablename]) Order By id
10是你想取多少条数据,150是条数×倍数。
也可以用这个来分页,分页的时候150就可以理解成条数×当前页码。自己理解下啊
请帮忙!我知道有种方法,可是不是最简单的,大家看看:
select *
from A
where id>(select max(id) from (select top 150 id from A) t1) and
id<=(select max(id) from (select top 160 id from A) t2)
请问还有更好的办法吗?