Oracle三种分页?

①select * from (select employee.*, rownum r from employee) where r between 2 and 5;

②select * from (select employee.*, rownum r from employee where rownum <= 5) where r >= 2;

③select * from (select e.*, rownum r from (select * from employee) e where rownum <= 5) where r >= 2;

posted @ 2018-04-15 22:59  清-华-园  阅读(105)  评论(0编辑  收藏  举报