SELECT employee_id, employee_name, salary FROM employees where rownum <

how will I find the first 5 highest salaried employees in
each dept in oracle.

Question Posted / manoj

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

Please Help Members By Posting Answers For Below Questions

Can objects of the same schema reside in different tablespace?

1107

How can I get column names from a table in oracle?

1108

Point out the difference between user tables and data dictionary?

1039

definition of cluster and non-clustered index?

3112

Please explain joins in oracle?

1110

material view and view disadvantages?

1128

Describe an oracle table?

1105

Explain compound trigger in oracle?

1091

What is oracle database client?

1082

What happens to the data files if a tablespace is dropped?

1110

What is a cursor in oracle?

1232

Explain the use of ignore option in imp command.

1090

What is the database name in oracle?

1082

why dont we assign not null constraint as table level constraint.

2800

What is columnar storage what is the advantage?

1125