Oracle分页

oracle 分页三种方式
1.rownum行号分页

 select * from yy ;

2.显示rownum[oracle分配的]

 select a.*,rownum rn  from  (select * from yy) a;

3.二分分页

 select * from  (select a.*,rownum rn   from (select * from yy) a where rownum<=10)  where rn>=6;

Oracle 不能用between and 所以想选取某个区间要分两次查询

a.指定查询列只需修改最里层的子查询(select * from yy)变为 select id，name from yy;
b.然后在最里层的的子查询加order by排序