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

What is a loop in sql?

1037

Does access use sql?

1101

What are the sql versions?

1000

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1184

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1124

What is composite data type in pl sql?

1170

How many times can we commit in a loop?

1067

what are the advantages and disadvantages of views in a database? : Sql dba

1074

What is pl sql record in oracle?

1089

Does user triggers have entry for trigger with compilation errors?

1091

What are the different dcl commands in sql?

1231

What is the use of desc in sql?

1022

Is primary key is clustered index?

1045

Can we use pl sql in mysql?

1063

How can you know that statistics should be updated?

1128