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

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3155

what is difference between sql plus and sql*plus? (not sql and sql plus).

3814

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1879

How to run queries on external tables?

990

query optmization techniques and quwry analyser+projects+ppts

2372

Is insert autocommit in oracle?

1019

How to write a left outer join with the where clause in oracle?

1027

Will you be able to store pictures in the database?explain.

931

What are the most common interview questions on ETL Testing for experience?

1079

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2153

How do we display rows from the table without duplicates?

920

Oracle

2321

How to use "out" parameter properly?

1028

What is pragma autonomous transaction in oracle?

993

How to check the server version in oracle?

1035