MySQL、Oracle分页查询语句

模拟分页查询处理

Mysql

select * from students
limit(page- 1) * pageSize,pageSize;

Oracle

oracle数据库需要创建一个伪列

select * from ( select rownum rn,* from students   ) where rn<=5 and rn>=3 ;

简单粗暴高效.