分页语句

取出sql表中第31到40的记录

sql server:方案一：select top 10 * from t where id not int (select top 30 id from t order by id) order by id

sql server:方案二：select top 10 * from t where id in ( select top 40 id from t order by id) order by id desc

mysql 方案：select * from t order by id limit 30,10

oracle方案：select * from ( select rownum r ,* from t where r<=40) where r>30