1.

Select Acc_No, sum(Amount) from Customer c, Transaction t where c.Acc_No=t.Acc_No group by c.Acc_No having Transaction_Type="Credit";

Answer»

2301003    65000

2201002   20000



Discussion

No Comment Found

Related InterviewSolutions