|
Re: query to find 2nd or 3rd maximum salary from emp table
ok friend do not worry i am sending one query for you .you try this.
select * from emp e where
2 =(select count(distinct sal) from emp where e.sal<=sal)
or 3=(select count(distinct sal) from emp where e.sal<=sal);
if you got the answer ok.otherwise u can send another thread to me .my mail id is:pradeep.tanugula@gmail.com.Please put subject as oracle query for second or third max salary.
Best of Luck.
byeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee....
TANUGULA PRADEEP
|