select * from ( select sal,rownum as num from (select sal from emp order

select top 3 sal from each dept?

Question Posted / kishore

Answer Posted / kishore

select * from (
select sal,rownum as num from (select sal from
emp order by sal desc))
where num <=3;

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Which is faster subquery or join?

1228

What is schema in sql?

956

What trigger means?

997

Which is faster joins or subqueries?

992

Why functions are used in sql?

999

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

998

define sql update statement ? : Sql dba

1126

What is the best partition size for windows 10?

1004

What is cte sql?

1002

explain the options of myisamchk to improve the performance of a table. : Sql dba

1022

How to test for null values?

1057

What is the primary use of normalization?

1012

Does view contain data?

1040

Can we use having without group by in sql?

988

What is the execution plan in sql?

1033