how to find the second highest salary from emp table?

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

Question Posted / shashank

211 Answers
368643 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 / sudhakar tripathi

select Max(salary) "2nd_Heigh_sal" from employees where
(salary < select Max(salary) from employees);

Is This Answer Correct ?

0 Yes

1 No

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

Answer / ajeshanath

select max(salary) from emp where salary not in
(select max(salary) from emp)

Is This Answer Correct ?

0 Yes

1 No

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

Answer / amy

select TOP salary from employee where salary in( select TOP 2 salary from employee order by salary desc) order by salary asc

Is This Answer Correct ?

0 Yes

1 No

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

Answer / praveen kumar.dandu

select a.sal,rank from(select sal,rank() over (order by sal
desc))a where rank=&n

<Here after printing the ranks we can retrieve we can
retreive what ever the rank we want>

Is This Answer Correct ?

2 Yes

4 No

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

Answer / sunil

select top 1 * from emp where sal not in (select max(sal)
from emp) order by sal desc

Is This Answer Correct ?

1 Yes

3 No

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

Answer / gokul

In MySQL, this query will be easier to find 2nd highest
salary and to fetch all the fields from a table.

select * from emp where sal not in (select max(sal)
from emp) order by sal desc limit 1

Is This Answer Correct ?

1 Yes

3 No

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

Answer / lakshmi

select * from (select *,rowcount()over (orderby emp desc)as
rank from emp)b where rank=2

Is This Answer Correct ?

0 Yes

2 No

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

Answer / abhijit banik

To get the n-th highest salary from employee table in oracle-10g
--------------------------------------------------------------
select min(salary)
from
(
select rownum rn, salary
from
( select distinct(salary) from employee order by salary desc )
)
where rn<=&n+1

Is This Answer Correct ?

1 Yes

3 No

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

Answer / arvind

rameshwari r u idiot dont u know the ans for this simple
que... worst fellow

Is This Answer Correct ?

1 Yes

4 No

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

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 u want

Is This Answer Correct ?

18 Yes

22 No

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

Post New Answer