oracle两种简单的分页

第一种：SELECT emps.* FROM (SELECT emp.*,ROWNUM  rn FROM EMP emp WHERE rownum<=5) emps WHERE emps.rn>=0;第二种：SELECT em.* FROM (SELECT emp.*,ROWNUM rn FROM EMP emp) em WHERE em.rn BETWEEN 5 AND 10;