SELECT salary FROM employee where rownum < 6 ORDER BY salary DESC gro

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

Question Posted / lakshya

Answer Posted / lakshya

SELECT salary FROM employee where rownum < 6 ORDER BY
salary DESC
group by dept;

Is This Answer Correct ?

11 Yes

39 No

Please Help Members By Posting Answers For Below Questions

What is materialized view in Oracle?

1048

How do I connect to oracle?

996

What is execute immediate in oracle?

970

Why does for update in oracle 8 cause an ora-01002 error?

960

How to get execution path reports on query statements?

949

Explain temporal data types in oracle

1056

What is a dynamic performance view in oracle?

959

How would you best determine why your MVIEW couldnt FAST REFRESH?

1863

How to estimate disk space needed for an export job?

1011

Explain the use of rows option in imp command.

1057

What privilege is needed for a user to delete rows from tables in another schema?

1034

What are the differences between lov and list item?

1019

What is oracle server autotrace in oracle?

1117

How to rollback the current transaction in oracle?

1011

What is ordinary table in oracle?

1098