how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 29302 Views
- IBM, I also Faced
- E-Mail Answers
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 |
How to define a data field as not null?
How to define a data source name (dsn) in odbc manager?
Is there a function to split a string in plsql?
What is difference between SUBSTR and INSTR?
how to hide the stored procedure inside a package
Difference between pre-select and pre-query
what is difference between table and view? where to use views? thanks in advance!
Why do we need oracle client?
How to rollback the current transaction in oracle?
What are the types of trigger in oracle?
what is the use of composite key constraint?
What is DTS and purpose of DTS ?
Oracle General 
