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


Please Help Members By Posting Answers For Below Questions

What is transaction control statement and how many types of transaction control statement in Oracle?

562


What is a database table in oracle?

572


How to assign values to data fields in record variables?

580


What is meant by an index?

619


Explain view?

577






How to bring a tablespace offline?

539


What are the extensions used by oracle reports?

571


What to do if the startbd.bat failed to start the xe instance?

609


How to define default values for formal parameters?

592


What is partitioned table in Oracle?

630


How to retrieve data from an cursor to a record?

559


What is the purpose of save points in oracle database?

541


Differentiate between post-database commit and post-form commit?

541


Point the difference between translate and replace?

570


What is blob datatype?

568