oracle 分页总结

1）分页查询一 select * from (select a1.*,rownum rn from (select * from student) a1 where rownum <=5) where rn>=2;

2)分页查询二 select a1.* from (select student.*,rownum rn from student where rownum <=5) a1 where rn >=3;

3)分页查询三 select a1.* from (select student.*,rownum rn from student) a1 where rn between 3 and 5;