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

Explain what are clusters?

1113

How to convert times to characters in oracle?

1027

Why packages are used in oracle?

1070

What is memory advisor in Oracle?

1078

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1119

20. Using a set operator, display the client number of all clients who have never placed an order.

2188

What is flashback in Oracle?

1022

What are the roles of dba?

1070

What is a named program unit?

1088

What is a subquery in oracle?

1112

How to build data dictionary view an new database?

1013

How to convert a date to char in oracle? Give one example.

1069

What the is the diff between local index and global index. give some example.

1642

What is oracle update statement with inner join ?

1065

Explain a private synonyms?

1043