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

Difference between oracle's plus (+) notation and ansi join notation?

1160

How to create a temporary table in oracle?

1337

What suggestions do you have to reduce the network traffic?

1024

How to assign a table row to a record variable?

1097

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1986

What is using clause and give example?

1109

Can we insert data in view oracle?

1120

What is the max number of columns in an oracle table?

1051

How do I uninstall oracle client from windows?

1062

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2603

What is analyze command used for?

1126

Can sub procedure/function be called recursively?

1053

how can we store any pdf file in oracle

2223

what is normalisation?what are its uses?

2336

How to do paging with oracle?

1053