how to find the second highest salary from emp table?

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

Question Posted / shashank

211 Answers
368614 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 / amol

select MAX (sallary) from emp where sallary<=(select MAX(sallary) from emp)

Is This Answer Correct ?

0 Yes

0 No

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

Answer / chandan

select slary from emp order by slary desc limit 1,1;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / tarun

SELECT salary FROM tb_salary ORDER BY salary DESC LIMIT 2,1

Is This Answer Correct ?

0 Yes

0 No

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

Answer / parvezkhan pathan

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

Is This Answer Correct ?

0 Yes

0 No

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

Answer / sai

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Is This Answer Correct ?

0 Yes

0 No

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

Answer / praveen

SELECT MAX(Salary) as 'Salary' from EmployeeDetails
where Salary NOT IN
(
SELECT TOP 1 (SALARY) from EmployeeDetails ORDER BY Salary Desc
)

Is This Answer Correct ?

0 Yes

0 No

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

Answer / pankaj kumar

SELECT filedname
FROM tablename
ORDER BY fieldname DESC
LIMIT 2 , 1

Is This Answer Correct ?

0 Yes

0 No

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

Answer / latha l

Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;

ENTER THE LEVEL MANUALLY

EX:Enter value for level: 2

YOU GET SECOND MAXIMUM SALARY.

Is This Answer Correct ?

0 Yes

0 No

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

Answer / nitin

select max(salary) from emp where salary<>(select
max(salary) from emp);

Is This Answer Correct ?

0 Yes

0 No

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

Answer / chiru

select distinct sal from emp e where 2=(select
count(distinct sal) from emp where e1.sal>e.sal) order by
sal desc;

Is This Answer Correct ?

0 Yes

0 No

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

Post New Answer