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 use of compress option in exp command.

969

What are the uses of linked server and explain it in detail?

1004

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2332

How to Truncate Table in Oracle

1094

How to create a new table in your schema?

1034

What is oracle update statement with inner join ?

994

Explain the use of indexes option in exp command.

1066

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2095

What is archive log in Oracle?

1071

How to use "in" parameter properly?

1006

what happened to the global index when I truncate the data in one of the partition?

1964

What is an oracle database table?

962

How to drop an index in oracle?

1022

How many categories of data types in oracle?

962

What is a oracle database?

996