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

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

969

How to define a sub function?

1084

Can you drop an index associated with a unique or primary key constraint?

970

Will you be able to store pictures in the database?

1063

What is a initialization parameter file in oracle?

989

Give the advantages and disadvantages of clusters.

997

How to update a table row with a record?

962

What are group functions in oracle?

975

What are the numeric comparison operations?

1056

Explain a private synonyms?

983

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1873

How to use like conditions in oracle?

996

Which is better Oracle or MS SQL? Why?

6267

How do I spool to a csv formatted file using sqlplus?

966

What is oracle instant client?

973