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 are data pump export and import modes?

611

How to set a transaction to be read only in oracle?

582

How to retrieve values from data fields in record variables?

572

Why does Oracle not permit the use of PCTUSED with indexes?

1953

How can we find out the duplicate values in an oracle table?

608

What are the differences between primary key and unique key?

515

What is the exact use of Collections?

1682

What are group functions in oracle?

585

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

612

Why use resource manager in Oracle?

665

How to drop an existing table in oracle?

592

How different is ms access and oracle?

547

What is the usage of synonyms?

590

How many types of database triggers exist?

575

What is a trigger and what are its types?

615