HI vaibhav Top n analysis is used for knowing the top most ranks.The syntax goes like this modify acc to ur reqirement.
select Rownum as rank,E.* from (select * from emp order by sal desc) where rownum<=2;
Gouthami
Quote:
Originally Posted by chandraismoon
Hi all
I want to display the entire row of the employee who is havong second highest sal
can any one help me
Vaibhav
|