主键不连续,不能用select * from tablename where id between n and m
最直接方案
select top m * from tablename where id not in (select top n id from tablename order by id)order by id
for sqlserver
主键不连续,不能用select * from tablename where id between n and m
最直接方案
select top m * from tablename where id not in (select top n id from tablename order by id)order by id
for sqlserver