oracle使用rownum做分页查询

qwiehcoqfy

select b.* from (select t.*,rownum rr from v_view_forta t ) b where b.rr  between 5 and 8 order by b.rr--1,13 表中group字段 020801020801020801020101050310021201021201021201030603060212021301-- 11,13 表中group字段 ,正确03060212021301-- 5,8 表中group字段 正确0105 0310021201021201select k.*,rownum rr from v_view_forta k where rownum between 2 and 6-- 1,100101010101040104010501050110011002011002011002-- 2,6 结果集为空！！！-- 这样写结果同上/*select g.*,rownum rr from v_view_forta g where rownum>=3 and rownum<=10*/select * from(select d.*,rownum rr from v_view_forta d ) p where p.rr>=2 and p.rr<=7--  1,100208010208010208010201010503100212010212010212010306-- 2,7  正确020801020801020101050310021201/*结论：使用rownum做分页查询，必须将rownum放在子查询内！否则不起作用！！！*/