Select * from emp where sal in (Select * From (Select sal from emp order b

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

Question Posted / ramya p

Answer Posted / ramya p

Select * from emp where sal in
(Select * From (Select sal from emp order by sal desc)
Where rownum < 3) order by sal desc;

Is This Answer Correct ?

6 Yes

18 No

Please Help Members By Posting Answers For Below Questions

When you have to use a default "rollback to" savepoint of plvlog?

1172

What are conditional predicates?

1037

Can we insert in view in sql?

1039

When is a declare statement required?

1130

How do we accept inputs from user during runtime?

1045

What is sql and its types?

1160

What is raw datatype in sql?

1030

what is a trigger in mysql? Define different types of trigger. : Sql dba

1053

What is sql lookup?

908

What are the different types of joins in sql?

1744

Explain what is an index?

1038

What is pl sql package?

1025

What is the need of a partition key?

976

what are all different types of collation sensitivity? : Sql dba

973

How do I find duplicates in the same column?

1066