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 partitioned table in Oracle?

1184

State the various uses of dbcc command?

1057

What are the different types of synonyms?

1135

Explain about functional dependency and its relation with table design?

1008

What does sharding mean?

995

How to set a transaction to be read only in oracle?

1091

Can you have more than one content canvas view attached with a window ?

2330

What is blob datatype?

1124

What is parameterized cursor in oracle?

1145

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4359

How to shutdown your 10g xe server?

1147

When do you get a .pll extension in oracle? Explain its importance

1039

Explain temporal data types in oracle

1093

Which is better Oracle or MS SQL? Why?

4933

How to use in conditions in oracle?

1056