Select * From cust_data Where trxn_type = 'CR' And sal = (Selec

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.

Question Posted / devraj

6 Answers
8113 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

Please Help Members By Posting Answers For Below Questions

What is an oracle cursor variable?

1131

How to put more than 1000 values into an oracle in clause?

1085

please explain.. DB architecture ...

2081

what is the difference between data migration and production migration.

2397

What is varray?

1195

Explain do view contain data?

1050

What is oracle used for?

1069

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5476

How to export several tables together?

1105

How many types of auditing in Oracle?

1086

How to check your oracle database 10g xe installation?

1042

Explain the use of consistent option in exp command.

1139

What is data block in Oracle?

1148

Explain the use of rows option in imp command.

1134

Is there any function in oracle similar like group_concat of mysql?

1105