how to find the second highest salary from emp table?

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

Question Posted / shashank

211 Answers
368584 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 / naveed saleh

You can use this for getting nth highest salary from
Employee table as follows

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
where n > 1 (n is always greater than one)

Is This Answer Correct ?

1 Yes

0 No

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

Answer / anantkreshna v

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / mona thakur

SELECT *
FROM emp
WHERE salary < (
SELECT max( salary )
FROM emp )
ORDER BY salary DESC
LIMIT 1

Is This Answer Correct ?

1 Yes

0 No

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

Answer / kishor

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / vijay shegokar

select * from employee where salary=(select max(salary) from
employee where salary not in (select max(salary) from
employee));

Is This Answer Correct ?

1 Yes

0 No

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

Answer / vijay kintali

select e1.ename,e1.sal from emp e1 where n=(select count
(distinct e2.sal) from emp e2 where e1.sal<=e2.sal);

Note:n here is nth highest salary.......

Is This Answer Correct ?

1 Yes

0 No

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

Answer / arvind

select max(salary) from table_name where sal<(select
max(salary) from table_name)

Is This Answer Correct ?

1 Yes

0 No

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

Answer / bharat puri

select top 2 (salary) from emp
order by salary desc

Is This Answer Correct ?

1 Yes

0 No

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

Answer / gurvinder

select max(sal)from emp where sal in(select sal from emp minus 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 sasmal

select distinct sal from emp e where 2=(select count(distinct sal)from emp s where e.sal<=s.sal)

Is This Answer Correct ?

1 Yes

0 No

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

Post New Answer