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 a table in oracle?

993

Explain oracle 12c new features for developers?

1063

What are the common oracle dba tasks?

1158

What is a system tablespace?

1092

How to use "while" statements in oracle?

1335

What are a query and state the different types of queries and their uses?

1021

What are the roles of dba?

1075

How do I manually create a database in oracle?

1031

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

1086

What is using clause and give example?

1059

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

2337

How to drop a stored function?

1144

How to write a query with a right outer join in oracle?

1176

What is max rowid in oracle?

1034

What is rowid and rownum in oracle?

1019