how to find the second highest salary from emp table?

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

Question Posted / shashank

211 Answers
367650 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 / krishna kishore

select top 1 salary from emp where salary in
(select top 2 salary from emp order by salary desc)
order by salary

Is This Answer Correct ?

1 Yes

0 No

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

Answer / kiran

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

/

Is This Answer Correct ?

1 Yes

0 No

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

Answer / ramcharan tej

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / anurag kumar rai

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / sachin verma

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / anil maurya

select top 1 rate from HumanResources.EmployeePayHistory
where rate<(select MAX(rate) as R from HumanResources.EmployeePayHistory)
order by rAte Desc

Is This Answer Correct ?

1 Yes

0 No

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

Answer / surendra sharma

select min(sal) from table_name where sal in

(SELECT top 2 sal FROM table_name order by sal desc)

Is This Answer Correct ?

1 Yes

0 No

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

Answer / yash goyal

Select Distinct salary
from employees e
where &no-1=(select count(distinct salary )
from employees
where E.salary < salary);

Is This Answer Correct ?

1 Yes

0 No

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

Answer / bharat g

select * from (select ename,sal,dense_rank() over (order by sal desc) ranking from emp) where ranking=2;

Is This Answer Correct ?

1 Yes

0 No

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

Answer / vinay

select max(sal) from emp where rownum = 2;

Is This Answer Correct ?

1 Yes

0 No

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

Post New Answer