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 exactly do quotation marks around the table name do?

965

How does Oracle guarantee data integrity of data changes?

2392

What do you mean by cdb and pdb in oracle 12c?

1062

What is dual table oracle?

987

How to connect ms access to oracle servers?

1009

How to check your oracle database 10g xe installation?

989

How to pass a cursor variable to a procedure?

1111

Explain the use of tables option in exp command.

1117

What is snapshot is too old? Give and example for better understand.

1605

What is the difference between hot backup and cold backup in oracle?

1014

What is the Tune Query

2295

Explain the importance of .pll extension in oracle?

1013

What is format trigger?

2075

What is the difference between PFILE and SPFILE in Oracle?

1062

Why oracle is used?

1061