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 would you get the current date in mysql? : Sql dba

911

What is the difference between explicit and implicit cursors in oracle?

996

What are the advantages of sql?

1005

Can you have a foreign key without a primary key?

899

what is bcp? When does it used? : Sql dba

932

Is it possible to link two groups inside a cross products after the cross products group has been created?

953

What is a design view?

883

Is join same as left join?

977

Explain table and field in sql?

1012

What is nosql vs sql?

1121

what are the drivers in mysql? : Sql dba

981

Is mariadb nosql?

988

What are the main features of cursor?

1038

How can we optimize a sql query?

982

What do you mean by rowid?

911