select top 3 sal,depno from emp where deptno in ( select deptno from em

select top 3 sal from each dept?

Question Posted / avinesh gupta

Answer Posted / avinesh gupta

select top 3 sal,depno from emp where deptno in
(
select deptno from emp group by deptno
)
order by sal desc

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How can I speed up sql query?

907

Can I call a procedure inside a function?

947

Where not exists in sql?

913

How to return an array from java to pl/sql?

1063

How does postgresql compare to "nosql"?

983

What is composite primary key in sql?

941

Can we write dml inside a function in sql server?

900

What is the difference between clustered and non-clustered index in sql?

959

Are stored procedures faster than queries?

903

What are synonyms in sql?

932

How to know the last executed procedure?

1037

What can you do with pl sql?

1036

How do I truncate a word?

1004

Why do we use joins in sql?

913

explain access control lists. : Sql dba

949