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
102861 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 / sandeep

select top(1) a.salary
from

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / mark berlin.

REM solution #1:
select * from(
select distinct nvl(salary,-1) as sal
from employees
where nvl(salary,-1) < (select max(nvl(salary,-1)) from
employees)
order by nvl(salary,-1) desc)
where rownum=1;
REM Solution #2
select * from (
select distinct salary from employees
order by salary
desc
)
where rownum < 3
minus
select * from (
select distinct salary from employees
order by salary
desc
)
where rownum =1;

Is This Answer Correct ?

1 Yes

0 No

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

Answer / sushant hole

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 / boby

select max(MAXI) from
(SELECT max(slno) AS MAXI FROM EMPLOYEE WHERE slno not IN(SELECT max(slno) FROM EMPLOYEE )
GROUP BY slno)a

Is This Answer Correct ?

1 Yes

0 No

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

Answer / naresh

select sal from emp e where 2= (select count(distntsal) from
emp y where e.sal<=y.sal);

Is This Answer Correct ?

1 Yes

0 No

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

Answer / neha singh

select min(sal)
from
(select sal from
(select sal from emp
order by sal desc)
where rownum<=2)

Is This Answer Correct ?

1 Yes

0 No

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

Answer / baburav zore

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / akshay

Select ename, eno, sal, rownum
from (select ename, eno, sal from emp order by sal desc)
where rownum = 2;

Is This Answer Correct ?

7 Yes

7 No

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

Answer / ahmad

Select Max(VacationHours) "MVacHrs"
from HumanResourcesEmployee
where VacationHours not in (Select Max(VacationHours)
from HumanResourcesEmployee)

Is This Answer Correct ?

2 Yes

2 No

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

Answer / google

Select min(sal) from emp where sal in (
select top 3 sal from emp
order by sal desc )

Is This Answer Correct ?

0 Yes

0 No

Post New Answer