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 / srikanth
select *from <TN>
where sal=(select max(sal) from <TN>);
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Design database draw er diagram for a certain scenario ?
What is the use of file param in imp command?
How to define a variable of a specific record type?
What is the difference between post-database commit and post-form commit?
Explain the use of analyse option in exp command.
Explain oracle instance.
State and explain the different types of data models?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Give the various exception types.
How to import one table back from a dump file?
How do I recompile a procedure in oracle?
How to pass a cursor variable to a procedure?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?