Transfer Rs 100 From Account A101 To A215 #534
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: Transfer Rs. 100 from account A-101 to A-215.
when account_number=’A-101′ then balance-100
when account_number=’A-215′ then balance+100
else balance
end;
Answer:
update account set balance = casewhen account_number=’A-101′ then balance-100
when account_number=’A-215′ then balance+100
else balance
end;
