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

Explain a segment?

619

How to do a full database export?

637

Explain do view contain data?

583

What is java oracle used for?

525

How to define a sub function?

666

What do you mean by a tablespace?

564

What is a nvl function?

566

How to bring a tablespace offline?

543

What is merge in oracle?

561

Explain the use of full option in exp command.

589

What is redo log?

623

What are the different types of failures that occur in Oracle database?

599

What do you understand by a database object?

588

How to sort the query output in oracle?

610

How to turn on or off recycle bin for the session?

610