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
- 7929 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 happens to the data files if a tablespace is dropped?
How to turn on or off recycle bin for the instance?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is a table in oracle?
How to write date and time literals in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How can I combine multiple rows into a comma-delimited list in oracle?
How to get execution path reports on query statements?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Compare and contrast between sql and sql server and explain its various functions?
6. Display the client name and order date for all orders using the traditional method.
What do you understand by a database object? Can you list a few of them?
What is the implicit cursor in oracle?
Why use resource manager in Oracle?
