ITPub博客

取出sql表中第31到40的记录（以自动增长ID为主键） 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   pageSize=20; pa