Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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 ?    217 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 ?    83 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 ?    43 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 ?    67 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 ?    29 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 4 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

More SQL PLSQL Interview Questions

How do I find duplicates in two columns?

0 Answers  


What is prepared statement in sql?

0 Answers  


How can a function retun more than one value in oracle with proper example?

0 Answers  


What are character functions in sql?

0 Answers  


Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  






Why do we need unique key in a table?

0 Answers  


Does inner join return duplicate rows?

0 Answers  


What is nvl function?

4 Answers   Cap Gemini,


What is the main difference between sql and pl/sql?

0 Answers  


what is sql server agent? : Sql dba

0 Answers  


what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,


How do you create a db file?

0 Answers  


Categories