Interested to Buy Any Domain ? << Click Here >> for more details...
how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 32924 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / manoj
SELECT employee_id, employee_name, salary FROM employees
where rownum < 6 ORDER BY
salary DESC
group by department_id;
| Is This Answer Correct ? | 4 Yes | 29 No |
Post New Answer View All Answers
What is the use of oracle?
How to rename a column in an existing table?
Explain the use of rows option in imp command.
How can we view last record added to a table?
What is merge statement used for?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is the scope of a local variable?
What are the restrictions on external table columns?
What types of joins are used in writing subqueries?
What happens if you use a wrong connect identifier?
What are the uses of a database trigger?
How many file formats are supported to export data?
In oracle there is column command, how will you explain that?
Explain oracle 12c new features for developers?
How to run the anonymous block again?
