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 / rajeev kumar
select max(salary) from <TN> where salary not in(select max
(salary) from <TN>)
salary->field name
Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What is transaction control statement and how many types of transaction control statement in Oracle?
What is a database table in oracle?
How to assign values to data fields in record variables?
What is meant by an index?
Explain view?
How to bring a tablespace offline?
What are the extensions used by oracle reports?
What to do if the startbd.bat failed to start the xe instance?
How to define default values for formal parameters?
What is partitioned table in Oracle?
How to retrieve data from an cursor to a record?
What is the purpose of save points in oracle database?
Differentiate between post-database commit and post-form commit?
Point the difference between translate and replace?
What is blob datatype?