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)