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

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3247

What is connection pool in oracle?

1039

Describe varray?

1118

How to do a full database export?

1153

6. Display the client name and order date for all orders using the traditional method.

2364

How many data types are supported?

1140

How to define an explicit cursor in oracle?

1102

Please explain joins in oracle?

1108

what is the dual table in oracle?

1041

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2042

What is the use of oracle?

1078

How to export data to a csv file?

1386

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2288

How to define an anonymous block?

1247

Explain the use of rows option in exp command.

1149