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 the difference between sap and oracle?

1002

What is oracle open database communication (odbc)?

986

What is a sub query? What are its various types?

1110

What privilege is needed for a user to create tables in oracle?

922

How to insert a new row into a table in oracle?

1124

Explain the features of oracle?

1001

What is query image?

948

What is the difference between postgresql and oracle?

1002

Is oracle a relational database?

892

Name the three major set of files on disk that compose a database in Oracle?

1085

Can the query output be sorted by multiple columns in oracle?

957

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1823

What is the difference between pre-select and pre-query?

1154

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2232

How do I connect to oracle?

996