SELECT * FROM (SELECT * FROM EMP ORDER BY SALARY desc) WHERE ROWNUM <

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

Question Posted / mangesh

Answer Posted / mangesh

SELECT * FROM (SELECT * FROM EMP ORDER BY SALARY desc) WHERE ROWNUM < 6;

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What happens in oracle commit?

985

What is the implicit cursor in oracle?

1059

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2917

Describe an oracle table?

1007

What is the difference between truncate & delete command?

1148

What is an oracle?

971

What are the original export and import utilities?

1095

Explain a synonym?

991

How to create a new tablespace in oracle?

950

Can we protect our pl/sql source code?

1010

what is port in oracle? how is it related to database application.

1907

What is the use of oracle?

1005

Explain oracle instance.

1127

IS it possible to built the oracle database without setting the kernal parameters?

2299

What is a lookup table in oracle?

954