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 do you mean by merge in oracle?
How to use in conditions in oracle?
How to pass a cursor variable to a procedure?
what is dynamic SGA and static SGA
Explain enable novalidate constraint.
How to end the current transaction in oracle?
What do you understand by a database object?
How to use "for" statements in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is query image?
What is a static data dictionary in oracle?
what is insert all statement in sql
How to create a stored program unit?
What is the difference between post-database commit and post-form commit?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?