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 / aswini
select * from <table_name> where salary in(select max
(salary) from <table_name>);
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the general rules on data consistency?
What is an oracle transaction?
How index is implemented in oracle database?
What are the attributes that are found in a cursor?
Give the constructs of a package, function or a procedure.
What is the Tune Query
Describe varray?
How can windows applications connect to oracle servers?
How to invoke the data pump import utility?
types of indexes and the rationale behind choosing a particular index for a situation.
What is raw datatype in oracle?
How to define and use table alias names in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to create a testing table in oracle?
What is the difference between PFILE and SPFILE in Oracle?