1、Oracle的分页查询:
使用rownum,两种如下:
第一种: select * from (select t.,rownum row_num from mytable t) b where b.row_num between 1 and 10
第二种: select * from ( select a., rownum rn from mytable a where rownum <= 10 ) where rn >= 1 使用rowid, 如下: select * from scott.emp where rowid in (select rd from (select rowid as rd ,rownum as rn from scott.emp ) where rn<=6 and rn>3);
2、mysql的分页查询:使用limit
select o.* from (sql) o limit firstIndex,pageSize;