how will I find the first 5 highest salaried employees in
each dept in oracle.
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 |
Post New Answer View All Answers
What is BBED in Oracle?
Explain about your project and its relation to the current job position you are applying to?
How to empty your oracle recycle bin?
how may join possible between (requisition with purchase order)
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to loop through a cursor variable?
what is normalisation?what are its uses?
How can windows applications connect to oracle servers?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is a tns service name?
What is data block in Oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is a nested table and how is it different from a normal table?
What is ADDM Advisor in Oracle?
What are nested tables?