select salary from employee where rownum<6 group by deptno,s

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

Question Posted / dhanalakshmi

Answer Posted / dhanalakshmi

select salary
from employee
where rownum<6
group by deptno,salary
order by salary desc

Is This Answer Correct ?

0 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Explain the use of record length option in exp command.

1120

What are a cluster and non-cluster index?

1065

How view is different from a table?

1089

What are transaction isolation levels supported by oracle?

1117

What are the logical operations?

1174

How can I get column names from a table in oracle?

1105

How many types of segments in Oracle?

1117

How to connect asp pages to oracle servers?

1122

What is the use of file param in imp command?

1218

what are archived logs?

2261

How much memory your 10g xe server is using?

1153

how to make an oracle object

2397

What is transaction control statement and how many types of transaction control statement in Oracle?

1236

How to use "if" statements on multiple conditions?

1217

How to turn on or off recycle bin for the session?

1174