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 sql query is executed?

1094

Explain the the update statement in sql?

1002

What is coalesce sql?

960

Can we rename a column in the output of sql query?

969

Can we perform dml in function?

1037

How to use boolean type in select statement?

1024

Explain the uses of database trigger.

1081

What are records give examples?

974

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

1260

What is a variable in sql?

972

Are stored procedures compiled?

889

What does seeding a database mean?

927

What is clustered index sql?

963

What is the use of triggers?

1006

what is 'mysqlimport'? : Sql dba

1000