Write a query to get 2nd maximum salary in an employee table ?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / wgk

69 Answers
116547 Views
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Write a query to get 2nd maximum salary in an employee table ?..

Answer / m

select max(sal) from emp where sal<(select max(sal) from
emp))

Is This Answer Correct ?

222 Yes

39 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / kotravel. b

SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

THIS will surly give 2^nd max sal ok this correct ans ok....

Is This Answer Correct ?

85 Yes

13 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / anil_abbireddy

select * from emp a where 2=(select count(distinct sal)
from emp b where a.sal<=b.sal)

Is This Answer Correct ?

44 Yes

12 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / sohail

select empno,ename,sal
from (select ename,empno,sal,dense_rank()
over(order by sal desc)topn
from emp)
where topn=2

Is This Answer Correct ?

69 Yes

46 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / anil_abbireddy

select * from emp a where 2=(select count(distinct sal)
from emp b where a.sal<=b.sal)

Is This Answer Correct ?

30 Yes

8 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / venkat

select max(sal) from emp where sal<(select max(sal) from
emp);

Is This Answer Correct ?

19 Yes

5 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / khandu shinde

select a.sal
from (
select sal ,rownum no
from (
select distinct sal
from emp
order by sal desc
)
) a
where a.no=2

Is This Answer Correct ?

16 Yes

6 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / abhay

Select Max(Sal)
From Emp E
Where E.Sal < (Select Max(Sal) From Emp)

Is This Answer Correct ?

9 Yes

1 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / uday

Hi friends i think it is surely work because i worked for this.

select * from emp e where 1=(select count(distinct d.esal)
from emp d where d.esal>e.esal)

any one plz try if it's not work

plz let me know.
uday_testing@yahoo.co.in

Is This Answer Correct ?

7 Yes

3 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / wei

The best answer should be the first one, this is because
the sql statement accesses table emp only once.

Is This Answer Correct ?

9 Yes

6 No

Post New Answer