select rownum as row_id,salary from (select salary from employees order b

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

Question Posted / sunil panghal

Answer Posted / sunil panghal

select rownum as row_id,salary from (select salary from
employees order by salary) where rownum <6;

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2148

Which is faster join or subquery in oracle?

950

How to find out what oracle odbc drivers are installed?

995

What is a proxy class?

987

What is a schema in oracle?

988

Why do we use bulk collect in oracle?

1030

Explain do view contain data?

956

What is enter substitution variable in oracle?

1007

How to unlock the sample user account in oracle?

955

How to rename a column in an existing table?

996

How to update values in a table in oracle?

979

What is a Garbage Collection? and what is full recursive Garbage collection?

2869

How to recover a dropped table in oracle?

1002

What is rowid and rownum in oracle?

973

What is the usage of save points in oracle database?

932