MySQL 分页sql话语练习

select top 10  * from t where id not in (select top 30 id from t order by id ） order by id;

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;

以以上语句为基础设计分页sql语句（直接利用sql语句进行分页，效率最高）

String sql = “select * from t limit”+(pageNo-1)*pageSize+”,”+pageSize;

select * from t limit (pageNo-1)*pageSize , pageSize;

oracle: sql = “select * from ” +

“(select rownum r,* from ” +

“(select * from articles order by postime desc)” +

“where rownum<= ” + pageNo*pageSize +”) tmp ” +

“where r>” + (pageNo-1)*pageSize;