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

Can there be more than one function with a similar name in a pl/sql block?

927

Are pl sql variables case sensitive?

1000

Is sql easier than java?

947

What are the two characteristics of a primary key?

927

what is msql? : Sql dba

943

Can two tables have same primary key?

917

Explain the working of foreign key?

977

What are the uses of merge?

1120

What is a rank in sql?

901

How to check if a column is nullable before setting to nullable?

1058

What is rownum?

924

What are all the different normalizations?

972

Are subqueries better than joins?

922

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1005

What is dense_rank in sql?

917