oracle 分页

#对员工进行工资排序，并且完成分页

select rs.* from (select rownum rn,t.* from (select first_name,salary from zx.employees order by salary desc) t where rownum <=5) rs where rs.rn>0  //从第几条开始

5的位置代表开始：start= （currentPage-1）* pageSize，10的位置代表结束：end  =  start + pageSize

select rs.* from (select rownum rn,t.* from (select first_name,salary from zx.employees order by salary desc) t where rownum <=10) rs where rs.rn>5