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

What are the built-in functions used for sending Parameters to forms ?

3342

State the various uses of dbcc command?

1022

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5371

Please explain compound trigger in oracle?

1017

How to delete a user account in oracle?

934

What is define in oracle?

1034

How to define an explicit cursor in oracle?

1002

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2183

What is the difference between a primary key & a unique key?

1059

How to export data to a csv file?

1247

Explain the types of exception?

1108

Explain the use of grant option in exp command.

1028

Why do we need oracle client?

913

What is the difference between alert log file and tarce file ?

2129

How can we find out the duplicate values in an oracle table?

1019