How to get top 3 earners in emp table of SCOTT's schema using SQL

[Taqi Hasan]

Hello
can any one tell me
How to get top 3 earners in emp table of SCOTT's schema using SQL.
I would appreciate for your prompt reply.
Regards.
Taqi

[SJ Adnams]

select a.ename from ( select ENAME , sal, rownum rowval from emp order by sal desc) a where rownum < 4;

[Taqi Hasan]

Thanks Lee for your kind information.
Regards.
Taqi