oracle是怎么分页的

select * from(
select rownum r,t.* from(
select e.* from emp e inner join dept d on e.deptNo = d.deptNo order by e.empNo desc ) t
where rownum < 9)
where r > 4;