how to get second highest salary in SQL(as/4000

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

Question Posted / guest

29 Answers
32256 Views
iGate, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to get second highest salary in SQL(as/4000..

Answer / premchand

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

Is This Answer Correct ?

34 Yes

12 No

how to get second highest salary in SQL(as/4000..

Answer / satheeshkumar

Select max(sal) From Employee where sal not in ( Select max
(sal) From Employee)

Is This Answer Correct ?

24 Yes

4 No

how to get second highest salary in SQL(as/4000..

Answer / sachin

select max(sal) from employees
where salary < (select max(sal) from employees);

Is This Answer Correct ?

19 Yes

3 No

how to get second highest salary in SQL(as/4000..

Answer / karunakarreddy.boyapally

SELECT DISTINCT A.SAL FROM EMP A
WHERE &N=(SELECT COUNT(DISTINCT(B.SAL)) FROM EMP B
WHERE A.SAL<B.SAL)

IF SUPPOSE IF U WANT 1 HIGEST SALARY GIVE N=1
IF SUPPOSE IF U WANT 2 HIGEST SALARY GIVE N=2
IF SUPPOSE IF U WANT 3 HIGEST SALARY GIVE N=3

Is This Answer Correct ?

10 Yes

1 No

how to get second highest salary in SQL(as/4000..

Answer / deepak

select max(sal) from emp where sal!=(select max(sal) from emp);

Is This Answer Correct ?

12 Yes

5 No

how to get second highest salary in SQL(as/4000..

Answer / raji_4u

select *
from emp e1
where 2 = ( select count(distinct sal)
from emp e2
where e1.sal <= e2.sal
)

Is This Answer Correct ?

8 Yes

1 No

how to get second highest salary in SQL(as/4000..

Answer / selvaraj v , anna univ coe

SELECT * FROM Employee e
WHERE 2=(SELECT COUNT(DISTINCT Salary) FROM Employee x
WHERE x.Salary >= e.Salary);

Is This Answer Correct ?

4 Yes

0 No

how to get second highest salary in SQL(as/4000..

Answer / sreekanth

SELECT MIN(SAL)
FROM(SELECT DISTINCT SAL FROM EMP
ORDER BY SAL DESC)
WHERE ROWNUM <= :N
where n is the nth highest salary.
In most of the answers,our friends have written 'where
rownum=2',but this never retreives a row.

Is This Answer Correct ?

5 Yes

2 No

how to get second highest salary in SQL(as/4000..

Answer / c srirammulu

select * from emp a where &n=(select count(distinct (sal))
from emp f where a.sal<f.sal)

Is This Answer Correct ?

4 Yes

1 No

how to get second highest salary in SQL(as/4000..

Answer / devi

select sal from (select sal,rank() over(order by sal desc)
as rank from emp) where rank>1 and rank<3

Is This Answer Correct ?

4 Yes

1 No

Post New Answer