数据分页查询

转载自传智播客论坛

sql server方案1：

      select top 10 * from t where id not in (select top 30 id from t order by id ) orde by id

sql server方案2：

      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

其实 这只是我们知道的！对于oracle 还有一个抓取