how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 27005 Views
- IBM, I also Faced
- E-Mail Answers
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 transport network substrate (tns) in oracle?
How to call a stored function in oracle?
How to define a sub function?
How to use like conditions in oracle?
what is meant by magic query
How to use fetch statement in a loop?
What are the system predefined user roles?
What are internal user account in oracle?
Respected sir, Please send me technical questions related to oracle apps..
How to sort the query output in oracle?
How to connect to the server with user account: sys?
How to use "in out" parameter properly?
please explain.. DB architecture ...
What is blob datatype?
Explain alias?
