select * from emp e where &n=(select count(distinct Sal)from emp where

select top 3 sal from each dept?

Question Posted / ramireddy

Answer Posted / ramireddy

select * from emp e where &n=(select count(distinct Sal)from
emp where Sal<=e.Sal);

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

how do you know the version of your mysql server? : Sql dba

1002

Why should I use postgresql?

1010

Explain the structure of pl/sql in brief.

1093

Explain what is table in a database?

1057

How do I partition in sql?

961

Are there any features that are decommissioned in 11g that are not present in 11g?

2147

Can we debug stored procedure?

1023

What are sql queries used for?

1023

How many rows can sqlite handle?

1110

What are schema-level triggers?

1100

What is rename in sql?

972

Can primary key be changed?

903

What are the advantages of pl sql?

1122

What is join view in sql?

944

what are the difference between clustered and a non-clustered index? : Sql dba

1030