SELECT *
FROM (SELECT ROWNUM rnum, emp.*
FROM (SELECT empno, ename, job, mgr, hiredate, sal, comm, deptno
FROM emp
ORDER BY empno DESC) emp)
WHERE rnum >= 1 AND rnum <= 10
FROM (SELECT ROWNUM rnum, emp.*
FROM (SELECT empno, ename, job, mgr, hiredate, sal, comm, deptno
FROM emp
ORDER BY empno DESC) emp)
WHERE rnum >= 1 AND rnum <= 10