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 |
State and explain the different types of data models?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
How to connect asp pages to oracle servers?
Can objects of the same Schema reside in different tablespaces.?
What is a table index?
Is oracle the best database?
What is the max number of columns in an oracle table?
How to convert characters to times in oracle?
What is merge in oracle?
What are privileges and grants?
How can we delete duplicate rows in a table?
What is a user account in oracle?