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

More SQL PLSQL Interview Questions

How do I find duplicates in two columns?

What is prepared statement in sql?

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

What are character functions in sql?

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..

Why do we need unique key in a table?

Does inner join return duplicate rows?

What is nvl function?

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

what is sql server agent? : Sql dba

what are pl/sql collections?

How do you create a db file?

Categories