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

List the parts of a database trigger.

1010

What is sharded cluster?

966

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2203

How do we create privileges in oracle?

1007

Oracle

2334

How to connect the oracle server as sysdba?

1034

What do database buffers contain?

981

How do I start tns listener?

1006

What is transport network substrate (tns) in oracle?

1009

Explain what are the type of synonyms?

1072

What is oracle open database communication (odbc)?

986

How to create a testing table in oracle?

966

How to drop a tablespace?

1012

How to convert a date to char in oracle? Give one example.

1018

State some uses of redo log files?

965