Query for second maximum salary in each in each department

Question Posted / kumar.rathan

Answers were Sorted based on User's Feedback

Query for second maximum salary in each in each department..

Answer / jairam

select deptno,Max(e1.sal) from emp e1
where e1.sal NOT IN(select Max(e2.sal) from emp e2
group by e2.deptno)group by e1.deptno

Is This Answer Correct ?

0 Yes

3 No

Query for second maximum salary in each in each department..

Answer / nancy singhal

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

Is This Answer Correct ?

0 Yes

3 No

Query for second maximum salary in each in each department..

Answer / sravan

Select first_name, salary, rownum rank from
(select *from emp order by salary desc)

Is This Answer Correct ?

0 Yes

5 No

Query for second maximum salary in each in each department..

Answer / sampath pallerla

select distinct(a.sal) from emp a where 2=(select count(distinct(b.sal)) from emp b where a.sal<=b.sal);

Is This Answer Correct ?

1 Yes

7 No

Query for second maximum salary in each in each department..

Answer / yaswanth

select salary from(select salary,rownum rk from(select salary from employees order by salary desc)) ehere rk=2;

Is This Answer Correct ?

2 Yes

13 No