SELECT EMPNO, ENAME, JOB, SAL FROM ( SELECT EMPNO, ENAME, JOB, SAL FROM EMP ORDER BY JOB DESC) WHERE ROWNUM <= 8
The statement only works in 8i and not in 8.0.5. So is there a way to get the TOP n records (after the sort) when there is an ORDER BY clause in 8.0.5?
Thanks,
Frank