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

How to write a query with a left outer join in oracle?

1061

How to define an oracle cursor variable?

1027

What is the sid in oracle?

961

What is oracle used for?

1022

Which are the five query types available in oracle?

949

How do we get field details of a table?

978

How to define and use table alias names in oracle?

939

How to check the oracle tns settings?

1045

What are triggers in oracle?

1032

What is meant by an index?

1136

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1879

What happens if the imported table already exists?

1030

What are the limitations oracle database 10g xe?

1044

Why cursor variables are easier to use than cursors?

1092

What are the various types of snapshots ?

1027