5. Display full details for the creditor/s who has received
the single largest payment. Do not use a table join or set
operator anywhere in your query.
Answer Posted / ajit
select *
from ( select sal from emp order by sal desc)
where rownum <= 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does oracle partitioning improve performance?
What is a partition in oracle?
Can we store images in oracle database?
What are transaction isolation levels supported by oracle?
How to write text literals in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is a system tablespace and when it is created?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to set a transaction to be read only in oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Explain about functional dependency and its relation with table design?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is the minimum client footprint required to connect c# to an oracle database?
Explain the use of inctype option in exp command.
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com