query to find 2nd or 3rd maximum salary from emp table

[sumahalesh28]

Hi friends,

Plse tel me the query to find the second and third maximum salary from emp table.

Thanks
suma

[sk_kireeti]

this is duplicate post...
n th max/min using SQL

[Jagadish chandra sabata]

Originally Posted by sumahalesh28

Hi friends,

Plse tel me the query to find the second and third maximum salary from emp table.

Thanks
suma

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);

[Jagadish chandra sabata]

check my query .

if any moore query please inform me

[pradeep_kumar]

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

[pallavi.patil]

how to find employee information whose salary is second highest salary in his department

my mail id : patil.pallavi@gmail.com