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

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

Please Help Members By Posting Answers For Below Questions

What is meant by an index?

1078

What is the difference between translate and replace?

1024

What are the set operators union, union all, minus & intersect meant to do?

952

Can we insert data in view oracle?

980

Is there any function in oracle similar like group_concat of mysql?

1007

How do you bind variables in oracle?

945

How to revoke create session privilege from a user in oracle?

977

Can we call procedure inside function in oracle?

1039

How do I connect to oracle?

992

How do I uninstall oracle 11g?

1066

Explain about the analyze command in oracle?

1014

Give the advantages and disadvantages of clusters.

1011

What is the usage of save points in oracle database?

927

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2112

What is save point in oracle database?

1259