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

What is tns service name?

1182

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1935

What is a trigger oracle?

1141

How to use attributes of the implicit cursor in oracle?

1067

what are steps for interface? where is exchange rate defined in which table?

2239

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2341

How do I know if oracle is installed on windows?

994

Can we store images in oracle database?

1068

What is the usage of merge statement?

1210

How to write a query with an inner join in oracle?

1102

How to export data with a field delimiter?

1089

What are the attributes that are found in a cursor?

1124

Which environment variables are absolutely critical in order to run the OUI?

2178

Why should I use oracle database?

1051

How to execute the package in oracle?

1139