select * from employee X where salary in (select top 5 salary

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

Question Posted / mihir nasikkar

Answer Posted / mihir nasikkar

select *
from employee X
where salary in (select top 5 salary
from employee
where dept = X.dept
order by salary desc)
order by dept, salary desc

Is This Answer Correct ?

2 Yes

4 No

Please Help Members By Posting Answers For Below Questions

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

2352

What is the difference between post-database commit and post-form commit?

1206

master table and child table performances and comparisons in Oracle ?

2139

What is oracle update statement with inner join ?

1067

What is a cursor and what are the steps need to be taken?

1205

definition of cluster and non-clustered index?

3035

Explain oracle 12c new features for developers?

1063

What is the relation of a user account and a schema in oracle?

1083

Whether any commands are used for months calculation? If so, what are they?

1099

How will you identify oracle database software release?

1016

What is a read only transaction in oracle?

1030

How to rename a column in an existing table?

1037

What is columnar storage what is the advantage?

1067

How to drop a tablespace?

1052

Difference between the “verify” and “feedback” command?

1372