Write a query to get 2nd maximum salary in an employee table ?
Answers were Sorted based on User's Feedback
Answer / m
select max(sal) from emp where sal<(select max(sal) from
emp))
Is This Answer Correct ? | 219 Yes | 39 No |
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 |
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 |
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 |
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 |
Answer / venkat
select max(sal) from emp where sal<(select max(sal) from
emp);
Is This Answer Correct ? | 19 Yes | 5 No |
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 |
Answer / abhay
Select Max(Sal)
From Emp E
Where E.Sal < (Select Max(Sal) From Emp)
Is This Answer Correct ? | 9 Yes | 1 No |
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 |
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 |
in procedure how to return a value
Is there a way to automate sql execution from the command-line, batch job or shell script?
Why we use stored procedure instead of query?
What is the use of count (*) in sql?
what is auto increment? : Sql dba
What is pseudo column ?
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
What are all the different normalization?
Can primary key be changed?
What is a database? Explain
What is latest version of sql?
Explain the the delete statements in sql?