select * (select sal from emp order by 1 desc) where rownum

select top 3 sal from each dept?

Question Posted / sen

Answer Posted / sen

select *
(select sal from emp
order by 1 desc)
where rownum < 4

Is This Answer Correct ?

1 Yes

13 No

Please Help Members By Posting Answers For Below Questions

How to select unique records from a table?

1059

What is scalar function?

1051

What is trigger in pl sql?

1001

How do you create a unique index?

1047

What is function and procedure in pl sql?

1044

What is the difference between unique and primary key constraints?

1071

Difference between truncate, delete and drop commands?

1082

Differentiate between % rowtype and type record.

1303

Is clustered index a primary key?

949

what is view? : Sql dba

959

How do you remove duplicate records from a table?

940

List and explain the different types of join clauses supported in ansi-standard sql?

1356

Why having clause is used in sql?

978

what is oracle database ? : Sql dba

1028

What are all the different normalization?

1037