SELECT * FROM (SELECT * FROM EMP ORDER BY SALARY desc) WHERE ROWNUM <

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

Question Posted / mangesh

Answer Posted / mangesh

SELECT * FROM (SELECT * FROM EMP ORDER BY SALARY desc) WHERE ROWNUM < 6;

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Difference between inner join vs where ?

1033

How to convert times to characters in oracle?

1025

Explain integrity constraints?

1102

How to list all tables in your schema?

1053

What are the differences between primary key and unique key?

1006

How to build data dictionary view an new database?

1006

List out the difference between commit, rollback, and savepoint?

1029

How to delete an existing row from a table in oracle?

1068

What are the common oracle dba tasks?

1141

How to connect to the server with user account: sys?

1013

Where is the export dump file located?

1143

What is ceil and floor in oracle?

1069

What are a query and state the different types of queries and their uses?

1011

Explain the use of Merge statement in oracle 11g

1025

how may join possible between (requisition with purchase order)

2243