有一个表Student~id字段是自动增长的int型~但是并不连续~想查看第31到41条记录,sql语句该怎么写?
select top 11 * from Student where id not in (select top 30 id from Student order by id) order by id
select top 11 * from Student where id not in (select top 30 id from Student order by id) order by id