I've done it again. They should be:

SELECT a.empno, a.ename
FROM (SELECT empno, ename
FROM emp
ORDER BY empno) a
WHERE empno > 0
AND rownum <= 10;

I forgot to replace the ID with EMPNO.

I'm sure I'm gonna get loads of abuse now. Duck and cover!

Tim...