select distinct sal from emp a where 5 >(select count (distinct sal) fr

how will I find the first 5 highest salaried employees in
each dept in oracle.

Question Posted / praveen marigaddi.

Answer Posted / praveen marigaddi.

select distinct sal from emp a where 5 >(select count
(distinct sal) from emp where sal>a.sal) order by a.sal desc

Is This Answer Correct ?

6 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Explain the function of optimizer in oracle?

1203

What is a trigger oracle?

1141

What is oracle rowcount?

1152

How to create a new user account in oracle?

1068

How to download oracle database 10g xe?

1070

What is the difference between I and G in Oracle?

1155

Explain the use of tables option in exp command.

1172

Why is oracle used?

983

What is the difference between pre-select and pre-query?

1305

State any two functions of oracle?

1101

How to turn on or off recycle bin for the instance?

1132

What is blob datatype?

1203

List out the difference between commit, rollback, and savepoint?

1096

How to use select statement to count the number of rows in oracle?

1096

How to define and use table alias names in oracle?

995