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
- 7910 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 is a procedure in oracle?
What is oracle database 10g express edition?
can u plz provide me oca sql dumps please i need them
What is the difference between 10g OEM and 11g OEM?
How to count duplicated values in a column in oracle?
How can we find out the current date and time in oracle?
What are the different types of record groups in oracle? Explain each of them
What is a sub query and what are the different types of subqueries?
Which is faster join or subquery in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
Is there a function to split a string in plsql?
Give the constructs of a package, function or a procedure.
How to convert dates to characters in oracle?
Can group functions be mixed with non-group selection fields?
Explain drop constraint oracle?
