Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 7639 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / devraj
Select * From cust_data Where trxn_type = 'CR' And sal =
(Select max(sal) From cust_data) And Rownum = 1;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Why do we use bulk collect in oracle?
What privilege is needed for a user to create indexes in oracle?
Hi Can any one tell me what are the API's used in requisition import.
How to use fetch statement in a loop?
What is system global area (sga) in oracle?
What is an oracle user account?
Is rowid unique in oracle?
How to create an oracle database?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to export data to a csv file?
Give the different types of rollback segments.
How to convert a date to char in oracle? Give one example.
Is it possible to insert comments into sql statements return in the data model editor ?
Is oracle a relational database?
How to view existing locks on the database?
