how to find the second highest salary from emp table?

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

Question Posted / shashank

211 Answers
368615 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 / sheela

Select top 2 sal from (select sal from emp order by sal
desc)

Is This Answer Correct ?

0 Yes

0 No

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

Answer / dsr

query:
======
select e.name,e.salary from emp e where &n =(select
count(distinct ee.salary) from emp ee where e.salary<=e.salary)

after run enter n value:

if 2 enter second max salary will come
if 3 enter third max salary will come.

otherwise, we can write below

select e.name,e.salary from emp e where 2 =(select
count(distinct ee.salary) from emp ee where e.salary<=e.salary)

Is This Answer Correct ?

0 Yes

0 No

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

Answer / nitin

SQL> select emp_sal from (select emp_sal from nitin order
by emp_sal desc) group by rownum,emp_sal
having rownum=2;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / rahul thakur

select top 1 salary from emp where id not in (select top1 id from emp order by salary desc)order by salary desc.

Is This Answer Correct ?

0 Yes

0 No

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

Answer / mastan

select name,salary from (select salary from emp order by
salary desc)where rownum<2

Is This Answer Correct ?

1 Yes

1 No

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

Answer / jyotiprokash

Select * from emp e1 where 1=(select count(distinct sal) from emp e2 where e1.salary<e2.salary)

Is This Answer Correct ?

1 Yes

1 No

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

Answer / raja

first find third maximum
then it ll be very easy to find second maximum.. :)

Is This Answer Correct ?

0 Yes

0 No

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

Answer / em rao

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

Is This Answer Correct ?

2 Yes

2 No

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

Answer / kameshwar shukla(a.i.e.t l.k.o

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

Is This Answer Correct ?

0 Yes

0 No

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

Answer / khushbu

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

Is This Answer Correct ?

0 Yes

0 No

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

Post New Answer