问题描述
我有一个表架构，如
事务(tran_id，tran_date_time，tran_amount，sending_acc_no，recieving_acc_no，
)
请注意:在这里，即使用户没有将金额发送到另一个帐户，而只是从其帐户中提取/存款，也将被称为交易" ...
现在，问题是我要执行一个迷你语句，该语句应包含以下各列:
小额陈述(tran_id，日期时间，[贷方/借方]，金额，余额)
我不知道从哪里开始..迅速的帮助将不胜感激.
Hi i have a table schema as
Transactions(tran_id , tran_date_time, tran_amount, sending_acc_no, recieving_acc_no,
)
Please note :Here, even if the user is not sending the amount to another account and he is just withdrawing/depositing from/in his account , it will be called a ''Transaction''...
Now , the issue is that i want to take a mini-statement which should have the following columns:
Ministatement(tran_id, datetime, [Credit/Debit],Amount, Balance)
I dont know where to start from..quick help would be highly appreciated.
regards.
推荐答案
这篇关于如何从交易表中提取迷你声明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！