MySQL 分页sql语句练习

[/align][align=left]
取出sql表中第31到40的记录（以自动增长ID为主键） 

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;