how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 27010 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 privilege is needed for a user to create tables in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What are the uses of synonyms?
What is oracle datasource?
What are the differences between number and binary_float in oracle?
How to create a new table in your schema?
What is blob datatype?
How many types of segments in Oracle?
How to commit the current transaction in oracle?
Explain the use of Merge statement in oracle 11g
How would you begin to troubleshoot an ORA-3113 error?
How to delete a column in an existing table?
What is index-organized table in Oracle?
How can windows applications connect to oracle servers?
How can we delete duplicate rows in a table?
