摘要:
解1:select top 10 * from A where id not in (select top 30 id from A)解2:select top 10 * from A where id > (select max(id) from (select top 30 id from A )as A)解3:select * from (select *, Row_Number() OVER (ORDER BY id asc) rowid FROM A) as A where rowid between 31 and 40 阅读全文