Write a query to get 2nd maximum salary in an employee table ?

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

Question Posted / wgk

69 Answers
118142 Views
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Write a query to get 2nd maximum salary in an employee table ?..

Answer / priya

select rownum,empno,sal from (select
rownum,empno,sal from emp order by sal desc) group
by rownum,empno,sal having rownum=2;

This will clearly work.............

Is This Answer Correct ?

6 Yes

3 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / nitika

SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

Is This Answer Correct ?

4 Yes

1 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / hasnain hameed

select max(salary)
from emp
where salary < (select max(salary) from emp)
order by salary desc;

i think this is correct answer all of above because it take
less time to execute. retrive the answer quickly.

Is This Answer Correct ?

6 Yes

4 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / kirti

Very simple answer: Arrange the top two salaries in
decending order. Select the mininum salary.

Select min(salary) from Employee where salary in(select top
2 salary from employee order by salary desc)

Is This Answer Correct ?

2 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / anupam274

use AdventureWorks

select * from HumanResources.EmployeePayHistory e where
2 = (select count(distinct Rate) from
HumanResources.EmployeePayHistory where e.Rate<=Rate)

select * from HumanResources.EmployeePayHistory e where
4 >(select count(distinct Rate) from
HumanResources.EmployeePayHistory where e.Rate<=Rate)

Is This Answer Correct ?

2 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / malli

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

Is This Answer Correct ?

2 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / gaurav mishra

The answer query is......

Select max(sal) from emp a where (&N-1) in(select count
(distinct(b.sal)) from emp b where a.sal<b.sal);

Is This Answer Correct ?

5 Yes

4 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / mallikarjuna

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

Is This Answer Correct ?

1 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / sanjib b

select last_name,salary from employees where salary =
(select max(salary) from employees
where salary <> (select max(salary) from employees))

Is This Answer Correct ?

1 Yes

0 No

Write a query to get 2nd maximum salary in an employee table ?..

Answer / sandeep

select top(1) a.name
from

(
select top(2) name,salary
from
employee
order by salary desc
)a
order by a.salary asc

Is This Answer Correct ?

1 Yes

0 No

Post New Answer