how will I find the first 5 highest salaried employees in
each dept in oracle.
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 |
Post New Answer View All Answers
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to define a sub function?
Can you drop an index associated with a unique or primary key constraint?
Will you be able to store pictures in the database?
What is a initialization parameter file in oracle?
Give the advantages and disadvantages of clusters.
How to update a table row with a record?
What are group functions in oracle?
What are the numeric comparison operations?
Explain a private synonyms?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to use like conditions in oracle?
Which is better Oracle or MS SQL? Why?
How do I spool to a csv formatted file using sqlplus?
What is oracle instant client?