How to get Max top 3 sal from emp table

[nandu]

Sorry I missed out a bit ! It is infact as follows...

select * from (select max(name), sal from t_emp
group by sal order by sal desc)
where rownum < 4

Cheers
Nandu