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

How to view the data files in the current database?

1045

Is java required for oracle client?

928

What are the advantages of oracle 12c?

1121

Explain coalesce function?

1119

What are a collation and state the different types of collation sensitivity?

1095

What is an oracle tablespace?

985

Can a formula column referred to columns in higher group ?

2458

What do you understand by database schema and what does it hold?

1180

How do I reset a sequence in oracle?

1052

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

978

How to define an explicit cursor in oracle?

989

How to work with data objects interactively?

927

How to use fetch statement in a loop?

973

How does the on-delete-cascade statement work?

1061

What is the usage of synonyms?

1062