select a.sal,a.emp_no from employee a where 5=(select distinct(count(*) fr

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

Question Posted / jas

22 Answers
31971 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / jas

select a.sal,a.emp_no from employee a
where 5=(select distinct(count(*) from
employee b where a.sal> b.sal)

Is This Answer Correct ?

8 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What happens to the data files if a tablespace is dropped?

996

Is oracle the best database?

915

How to loop through data rows in the implicit cursor?

1016

What do you understand by database schema and what does it hold?

1180

Can we save images in a database and if yes, how?

1002

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1326

Is primary key indexed by default in oracle?

931

How to delete a column in an existing table?

1020

What is an oracle cursor variable?

1008

What do you mean by cdb and pdb in oracle 12c?

1008

How to open and close an explicit cursor in oracle?

1002

What are the original export and import utilities?

1058

What is SQL access advisor in Oracle?

1137

What is a connect identifier?

983

What is an oracle recycle bin?

932