how will I find the first 5 highest salaried employees in
each dept in oracle.
Answers were Sorted based on User's Feedback
Answer / lakshya
SELECT salary FROM employee where rownum < 6 ORDER BY
salary DESC
group by dept;
Is This Answer Correct ? | 11 Yes | 39 No |
What is Water Mark in Oracle?
Describe varray?
What is self-referential integrity constraint ?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
What is the difference between substr and instr?
How many types of segments in Oracle?
a query to select maxmun 3 salaries of employee table
How to end the current transaction in oracle?
Give the different types of rollback segments.
What is oracle host variable?
Difference between hot backup vs. Cold backup?
what is the difference between restoring and recovering?