如何从交易表中提取迷你声明 [英] How to take a mini-statement from transaction table

问题描述

我有一个表架构，如

事务(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.

推荐答案

Hello Shikhar，


对帐户或您要针对的帐户执行火灾查询，然后在临时表中按desc顺序进行排序.完成后，将获得前10个值.


谢谢
sanjeev.

Hello Shikhar,


fire query agianst the account or against which you want and then make order by desc in a temp table. once you done with it take top 10 value.


thanks
sanjeev.

这篇关于如何从交易表中提取迷你声明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！