ITPub博客

1.分页语句怎么取出表中第31到40的记录（以自动增长ID为主键）   sql server方案1：    select top 10 * from t where id not in (select top 30 id from t order by id ) order 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 and r>=30) 2.分页技术1（直接利用sql语句进