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

Query for second maximum salary in each in each department

Question Posted / manju

Answer Posted / manju

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 ?

13 Yes

10 No

Please Help Members By Posting Answers For Below Questions

How do you modify a trigger?

524

What is pl sql in dbms?

503

Is left join inner or outer?

583

What is a primary key? Explain

541

How does left join work in sql?

516

what is sql in mysql? : Sql dba

569

What is pl/sql language case sensitive?

632

What language is oracle sql developer?

508

what are aggregate and scalar functions? : Sql dba

550

How many rows can sqlite handle?

585

Does pl sql work in mysql?

534

What are triggers in sql?

580

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1638

What are packages in pl sql and also explain its advantages?

532

How do I view stored procedures?

540