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

How can you fetch first 5 characters of the string?

1066

Which kind of parameters cannot have a default value in pl sql?

1212

Explain raise_application_error.

1145

How many disk partitions should I have?

1041

How do you remove duplicates without using distinct in sql?

1019

What is sql and explain its components?

1119

Is it possible to create the following trigger: before or after update trigger for each row?

1353

How many sql statements are used?

1072

Does a join table need a primary key?

1000

What is localdb mssqllocaldb?

1106

What are stuff and replace function?

1142

What does count (*) mean in sql?

1654

What is the default isolation level in sql server? : Transact sql

1088

what are the drivers in mysql? : Sql dba

1060

what is a control file ? : Sql dba

1090