select a.sal,a.emp_no from employee a where 5=(select distinct(count(*) fr

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

Question Posted / jas

Answer Posted / jas

select a.sal,a.emp_no from employee a
where 5=(select distinct(count(*) from
employee b where a.sal> b.sal)

Is This Answer Correct ?

8 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is clustered table in Oracle?

1262

What are the common oracle dba tasks?

1204

Explain the use of ignore option in imp command.

1087

What is a nvl function? How can it be used?

1099

What is oracle data type?

1012

What is private procedure oracle?

1050

How do I find the database name in oracle?

1090

Explain database link?

1176

How to use "in" parameter properly?

1120

How to install oracle odbc drivers?

1146

What are the data types in oracle?

1098

Explain what are the different type of segments?

1004

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2320

Who developed oracle & when?

1059

How to generate query output in html format?

1212