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

Explain do view contain data?

956

How can I create database in oracle?

975

What is null value in oracle?

1062

What is the disadvantage of User defind function?

2261

How to export several tables together?

1008

What is bind variable in oracle 11g?

1011

Explain oracle insert into command?

1072

What is a partition in oracle?

1063

Whether any commands are used for months calculation? If so, what are they?

1057

what is a Nested Loop join?

2057

How to define a data source name (dsn) in odbc manager?

989

How to write date and time literals in oracle?

968

how do u setup a replication site?

1948

Explain an index?

1107

what is the scenario where you take the database to NoArchivelog mode?

2287