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

Query for second maximum salary in each in each department

Question Posted / jairam

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Explain spool.

1114

What are the different parts of a package?

1043

What are the two virtual tables available at the time of database trigger execution?

1160

what are the 'mysql' command line options? : Sql dba

1018

How to run pl/sql statements in sql*plus?

1024

explain what is mysql? : Sql dba

1032

Can a varchar be a primary key?

955

Can you select everything, but 1 or 2 fields, without writer's cramp?

934

What is blind sql injection?

992

What is microsoft t sql?

882

Which is better join or subquery?

1067

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1076

Is it important to partition hard disk?

967

What does varchar include?

908

what tools available for managing mysql server? : Sql dba

1011