select * from(select emp.*, dense_rank() over(partition by deptno order by

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

Question Posted / shareef

Answer Posted / shareef

select * from(select emp.*,
dense_rank() over(partition by deptno order by sal desc) r
from emp) where r<=5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What would you do with an in-doubt distributed transaction?

1975

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

1082

How to establish administrator authentication to the server?

1034

what is a Nested Loop join?

2104

Can we use bind variables in oracle stored procedure?

948

What is sharded cluster?

1008

How can we delete duplicate rows in a table?

971

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2118

What is the quickest way to export a table to a flat file?

965

How view is different from a table?

1028

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4358

What do you mean by a deadlock?

1059

How to use subqueries in the from clause in oracle?

1108

What are the different types of trigger and explain its various uses and functions?

1085

What are the numeric comparison operations?

1109