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
Explain the use of analyse option in exp command.
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to create a testing table in oracle?
How many types of table in Oracle?
what is the difference between data migration and production migration.
Why does for update in oracle 8 cause an ora-01002 error?
How to define a variable to match a table column data type?
What happens to the current transaction if a ddl statement is executed?
Point out the difference between user tables and data dictionary?
Point the difference between translate and replace?
How to lock and unlock a user account in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is raw datatype?
What are privileges and grants?
6. Display the client name and order date for all orders using the traditional method.