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

what are the default admin accounts in Oracle 10g ?

941

Explain integrity constraint?

1126

Is it possible to insert comments into sql statements return in the data model editor ?

2529

How to create an oracle database manually?

1044

What is dual table oracle?

944

How to select an oracle system id (sid)?

1032

How to get maxsal , minsal, ename department wise in single query

1518

What is the usage of control file in oracle?

1050

Explain integrity constraints?

1076

What are the extensions used by oracle reports?

1011

How to view all columns in an existing table?

897

How to export your connection information to a file?

1097

How to get a create statement for an existing table?

927

What is a read write transaction in oracle?

1053

Can a formula column referred to columns in higher group ?

2476