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 BBED in Oracle?

1201

Explain about your project and its relation to the current job position you are applying to?

1080

How to empty your oracle recycle bin?

1077

how may join possible between (requisition with purchase order)

2334

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

1096

How to loop through a cursor variable?

1128

what is normalisation?what are its uses?

2336

How can windows applications connect to oracle servers?

1119

What do you mean by a database transaction & what all tcl statements are available in oracle?

1040

What is a tns service name?

1058

What is data block in Oracle?

1155

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2234

What is a nested table and how is it different from a normal table?

1114

What is ADDM Advisor in Oracle?

1227

What are nested tables?

1227