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

What happens in oracle commit?

1027

what is the difference between substr and instr function in oracle?

1090

what is Single Byte Overhead...?

2556

How to list all indexes in your schema?

1093

How to use "while" statements in oracle?

1327

How to find out what oracle odbc drivers are installed?

1042

What is concurrency in oracle?

1008

What is java oracle used for?

1026

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2325

What is the dynamic sql in oracle?

1073

How do I find the database name in oracle?

1039

How to connect ms access to oracle servers?

1009

What is oracle in java?

972

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

How do we get field detail of a table?

1081