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 many rows can sqlite handle?

1162

Is it possible for a table to have more than one foreign key?

1082

Can you select everything, but 1 or 2 fields, without writer's cramp?

1039

How many disk partitions should I have?

1041

Why is nosql good?

1083

What is join view in sql?

989

How do you optimize a query?

1060

What is sql exception?

1012

what are aggregate and scalar functions? : Sql dba

1108

How do I view a table in sql?

1041

What is sql keyword?

1044

How delete a row in sql?

1042

Explain the purpose of %type and %rowtype data types with the example?

1047

Differentiate between syntax and runtime errors.

1242

How many types of index are there?

1102