how to find the second highest salary from emp table?

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

Question Posted / shashank

211 Answers
368632 Views
CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to find the second highest salary from emp table?..

Answer / sudha

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

Is This Answer Correct ?

1 Yes

0 No

how to find the second highest salary from emp table?..

Answer / pranav damele

All the above one works with Oracle; this one is for MYSQL

second highest :
mysql> select * from employee group by salary desc limit 1,1;

limit 1,1; first '1' means that bring cursor to the end of record and the next '1' means number of records to be printed after the cursor position.

third highest:
mysql> select * from employee group by salary desc limit 2,1;

limit 2,1; '2' means that bring cursor to the end of 2nd record and the next '1' means number of records to be printed after the cursor position.

Is This Answer Correct ?

1 Yes

0 No

how to find the second highest salary from emp table?..

Answer / mohamed hussain

select salary from
(select salary,Dense_RANK() over (Order by salary desc) as
Level from salary) TMP
where Level=@Level

Is This Answer Correct ?

1 Yes

0 No

how to find the second highest salary from emp table?..

Answer / esakki

select max(salary) from employee where salary not in (select
top 1 salary from employee order by salary desc )

change 1 to 2,3,4,......like that for 3rd max ,4th max
salary.....

Is This Answer Correct ?

1 Yes

0 No

how to find the second highest salary from emp table?..

Answer / prashanth

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

Is This Answer Correct ?

1 Yes

0 No

how to find the second highest salary from emp table?..

Answer / ashwini

select top 1 salary from emp where salary in (select top 2
salary from emp order by salary asc) order by salary desc

Is This Answer Correct ?

1 Yes

0 No

how to find the second highest salary from emp table?..

Answer / naveen r kumar

SELECT Max(salary) FROM TABLE
WHERE salary NOT IN (SELECT Max(salary) FROM TABLE);

Is This Answer Correct ?

1 Yes

0 No

how to find the second highest salary from emp table?..

Answer / jhansi

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

Is This Answer Correct ?

1 Yes

0 No

how to find the second highest salary from emp table?..

Answer / sankar

select * from emp where sal=(select max(sal) from emp where
sal not in(select max(sal) from emp))

Is This Answer Correct ?

1 Yes

0 No

how to find the second highest salary from emp table?..

Answer / pramila

not only seceond highest . you can retrieve 2nd , 3rd.....
highest salary form this query

select min(Salary) from
(select distinct top 2 Salary from tblCategory order by
Salary desc) as tblCategory

Is This Answer Correct ?

1 Yes

0 No

1
..3
..6
..9
..12
..15
..18
..21
22

Post New Answer