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
State and explain the different types of data models?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Explain user account with reference to oracle.
What is the relation of a user account and a schema?
How to export your own schema?
Explain the use of rows option in exp command.
What is an Oracle index?
How do you find current date and time in oracle?
Explain coalesce function?
What are the advantages of oracle 12c?
What is truncate oracle?
What is a sub query? What are its various types?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance