SELECT dept, MAX(sal) FROM EMP WHERE sal NOT IN (SELECT MAX(sal) FROM emp

i need department wise top 2 employees salary.which logic
i will use

Question Posted / neetika vardhan

17 Answers
32705 Views
I also Faced
E-Mail Answers

Answer Posted / neetika vardhan

SELECT dept, MAX(sal)
FROM EMP WHERE sal NOT IN (SELECT MAX(sal) FROM emp GROUP
BY dept)
GROUP BY dept

UNION

SELECT dept, MAX(sal)
FROM EMP
GROUP BY dept

Is This Answer Correct ?

17 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which is faster union or join?

1025

Mention what are the benefits of pl/sql packages?

1156

What problem one might face while writing log information to a data-base table in pl/sql?

1250

What are % type and % rowtype?

1081

How do you determine the current isolation level? : Transact sql

1206

Mention what is the use of function "module procedure" in pl/sql?

1088

What is a pragma statement?

1335

Is a foreign key always unique?

983

What packages are available to pl/sql developers?

1111

how do you tune the slow running queries in oracle db , explain the methodology

3230

What is procedure in pl sql?

1090

What is right join in sql?

1157

Why do we use procedures in sql?

1141

Can we rollback truncate?

1050

define sql insert statement ? : Sql dba

1080