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排序