Oracle分页语句

select * from  (select a1.*,rownum rn from (select * from 表) 表别名 where rownum <上限) where rn>= 下线

 

select * from employe  where employeid in (select employeid from (select employeid,rownum rn from (select employeid from employe) where rownum <= 4) where rn >=2)