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
- 5986 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
What privilege is needed for a user to delete rows from tables in another schema?
What is open database communication (odbc) in oracle?
What is index in Oracle?
What is max rowid in oracle?
How to invoke the data pump export utility?
What is the usage of save points in oracle database?
How to insert a record into a table?
What is a cognitive schema?
Explain the dml?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What are set operators?
How to manage transaction isolation level?
How to download oracle database 10g xe?
What is difference between truncate and delete?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
