如何让客户列出过去7天没有存款的客户？ [英] How to get the customers list those who are not depositing money from last 7 days ?

问题描述

我的想法是使用自我加入比较过去7天的余额。



1.如果过去7天的余额没有差异，那么客户没有存款。



2.如果过去7天的余额存在差异，那么客户将存入款项。



我尝试了什么：



我试过的是自我加入成功但不是了解如何指定该比较的最后7天。

My idea is to by using self join comparing the balance in the last 7 days.

1. If no difference in balance from last 7 days, then the customer is not depositing the money.

2. If there is a difference in balance from last 7 days, then the customer is depositing the money.

What I have tried:

what i have tried is applied self join successfully but not getting how to specify last 7 days to that comparison.

推荐答案

在每个交易中生成的数据中，必须包含交易的日期和类型，例如信用卡和借记卡。它们是存储在某些数据库表中的基本数据，用它们来实现您的目标。如果没有在数据库中捕获它们，那么您应该重新查看数据库设计。

Of the data that are generated in every transaction there bound to include a date and type of transaction, e.g. credit and debit. They are essential data that are to be stored in some database tables, use them to achieve your objective. If they are not captured in the database, then you should re-look into your database design.

这篇关于如何让客户列出过去7天没有存款的客户？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！