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

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1172

How much ram can sql express use?

992

How does postgresql compare to oracle/db2/ms sql server/informix?

1039

What is the difference between rename and alias?

1346

How can use stored procedures in sql?

1144

what are the authentication modes in sql server? : Sql dba

1067

What are different types of functions in sql?

1008

What is basic structure of pl sql?

1074

Why do we need unique key in a table?

961

How do I run a sql query?

1028

What is a database trigger?

1072

Is sql between inclusive?

1139

What is join view in sql?

949

What are the advantages of sql?

1055

What are the parts of a sql statement?

1090