请教：SQL语句--我想找出某一个账户在七天之内的发生额超过5万的情况？

Question

请教老师：

我想使用SQL语句，找出来某一个账户在某七天之内发生额累计大于5万的数据？
例如：银行有一个规定，个人外币存款账户七日内不能取款累计超过5万，我想在个人存款账户流水账中找出来，哪个账户在哪个七天之内取款超过了5万
个人存款账户流水账中条件有：账号、日期、发生额

Answer 1

;with  t(Account,TransactionDate,TransactionAmount) AS(
     select '1111','10/12/2016',12450 union all
    select '1111','10/09/2016',500 union all
    select '2222','10/11/2016',25000 union all
    select '2222','10/12/2016',10000 union all
    select '2222','10/09/2016',15000 union all
    select '3333','10/10/2016',10000 union all
    select '3333','10/01/2016',50000 
 )
select Account,sum(TransactionAmount) from t
where datediff(d,TransactionDate,getdate())<=7
group by Account
having sum(TransactionAmount)>=50000

返回账号2222