select rownum as row_id,sal from (select sal from emp order by sal desc)

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

Question Posted / rammohan

Answer Posted / rammohan

select rownum as row_id,sal from (select sal from
emp order by sal desc) where rownum <6;

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the data type of dual table?

1069

How to create a server parameter file?

1188

What is SQL Tuning Advisor in Oracle?

1256

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2120

How to drop an existing view in oracle?

995

What is sharded cluster?

1073

How to invoke the data pump import utility?

1233

What is the difference between $oracle_base and $oracle_home?

1140

Why do we use coalesce function in oracle?

1169

How to define a record variable to store a table row?

1113

How to loop through a cursor variable?

1128

What is the meaning of recursive hints in oracle?

1102

What are the different types of modules in oracle forms?

1053

How to use like conditions in oracle?

1115

Where do you use decode and case statements?

1045