how to find the second highest salary from emp table?

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

Question Posted / shashank

211 Answers
368656 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 / abhishek jaiswal

select salary from employees a where &nth_highest_salary =(select count(distinct salary)
from employees b where a.salary<=b.salary)
/

Is This Answer Correct ?

1 Yes

0 No

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

Answer / mohammed irfan

SELECT sal1 "salary"
FROM (SELECT ROWNUM rownum1 ,sal1
FROM (SELECT sal sal1
FROM emp
ORDER BY sal DESC
)
)
WHERE rownum1=:p_highest;

Note:- 'p_highest' here we can give the number as we want
to display the highest salary.

Is This Answer Correct ?

1 Yes

1 No

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

Answer / ruma

select *from emp order by sal desc limit 1,1

Is This Answer Correct ?

5 Yes

5 No

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

Answer / hitesh pundir

select max(salary)from m1 where salary <>(select max(salary)
from m1)

Is This Answer Correct ?

2 Yes

2 No

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

Answer / vinay

It works gr8...

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

Is This Answer Correct ?

2 Yes

2 No

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

Answer / mallika

SELECT salary FROM employee a
WHERE &n IN (SELECT COUNT(*) FROM employee b
WHERE a.salary <= b.salary)

Is This Answer Correct ?

2 Yes

2 No

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

Answer / neeraj

SELECT DISTINCT(SAL) FROM EMP
WHERE SAL=(SELECT MIN(SAL) FROM (SELECT SAL FROM EMP ORDER
BY SAL DESC)
WHERE ROWNUM<=2);

Is This Answer Correct ?

2 Yes

2 No

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

Answer / sathiavathi

select max(salary) from employee where salary!=(select max
(salary) from employee);

Is This Answer Correct ?

1 Yes

1 No

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

Answer / sarojkant

select max(salary ) from emp table where sal<(select max
(salary)from emp table)

Is This Answer Correct ?

0 Yes

0 No

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

Answer / sarojkant

select sal from emp
where rownum=2
order by sal desc

Is This Answer Correct ?

0 Yes

0 No

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

Post New Answer