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
What is bulk copy or bcp in oracle?
Are truncate and delete commands same? If so why?
How index is implemented in oracle database?
How to create an oracle database?
How many types of tables are there in oracle?
How to turn on or off recycle bin for the session?
What are the different oracle database objects?
How to open a cursor variable?
How to rollback the current transaction in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Compare and contrast between sql and sql server and explain its various functions?
What is integrity and what is constraint??Explain with example
Is a rollback possible to any savepoint?
How to rename an existing table?
What is the difference between post-database commit and post-form commit?