Waive Off All The Loans With Amount Lt 1000 #536
This subjective question is related to the book/course
gs gs114 Relational Database Management System.
It can also be found in
gs gs114 Practical Questions Solved Past Paper No. 1.
Question 1: Waive off all the loans with amount < 1000.
delete from loan where amount<1000;
Answer:
delete from borrower where loan_number in (select loan_number from loan where amount<1000);delete from loan where amount<1000;
