SELECT * FROM (SELECT * FROM EMP ORDER BY SALARY desc) WHERE ROWNUM <

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

Question Posted / mangesh

22 Answers
32843 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / mangesh

SELECT * FROM (SELECT * FROM EMP ORDER BY SALARY desc) WHERE ROWNUM < 6;

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to pass parameters to procedures?

1039

Why is oracle so popular?

1005

Can group functions be used in the order by clause in oracle?

999

material view and view disadvantages?

1079

What's dateware house and what's clustor with practicle example

2179

What are the different types of modules in oracle forms?

1002

How to load data from external tables to regular tables?

1063

What is the usage of save points in oracle database?

965

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2022

How to fetch the row which has the max value for a column?

1002

How to write an inner join with the where clause in oracle?

1047

Respected sir, Please send me technical questions related to oracle apps..

1815

Point the difference between translate and replace?

1096

What is BBED in Oracle?

1161

How to rename a column in an existing table?

1037