TYPE=VIEW
query=select max(`co-operativebank-purbadekhali`.`loan_deposit`.`loan_id`) AS `loan_id`,`co-operativebank-purbadekhali`.`loan_deposit`.`Acc_No` AS `acc_no`,sum(`co-operativebank-purbadekhali`.`loan_deposit`.`prin_amt`) AS `prin_amt`,max(`co-operativebank-purbadekhali`.`loan_deposit`.`Date`) AS `Date` from `co-operativebank-purbadekhali`.`loan_deposit` group by `co-operativebank-purbadekhali`.`loan_deposit`.`Acc_No`
md5=ce9d9081dd144a27ee1f3e5fe6905cb5
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2023-08-09 12:25:37
create-version=1
source=SELECT max(`loan_id`) as loan_id, acc_no,sum(prin_amt) as prin_amt,max(Date) as Date FROM `loan_deposit` group by acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select max(`co-operativebank-purbadekhali`.`loan_deposit`.`loan_id`) AS `loan_id`,`co-operativebank-purbadekhali`.`loan_deposit`.`Acc_No` AS `acc_no`,sum(`co-operativebank-purbadekhali`.`loan_deposit`.`prin_amt`) AS `prin_amt`,max(`co-operativebank-purbadekhali`.`loan_deposit`.`Date`) AS `Date` from `co-operativebank-purbadekhali`.`loan_deposit` group by `co-operativebank-purbadekhali`.`loan_deposit`.`Acc_No`
