实现功能:总共需要支付500万资金,分四次计算,要求显示每天支付资金以及
剩余待支付资金。这里使用over函数完成聚簇显示
select t1.paymoney/10000 paymoney, t1.paymadedate,',
(( select sum(t2.notemoney )
from t_innerapplies t2
where t2.psselnum ='PS0_22200000002014112800158741')-
sum(sum(t1.recmoney))over(order by paymadedate rows between unbounded preceding and current row) --计算剩余资金
)/10000 remaindmoney
from t_payments t1, t_innerapplies t3
where t3.psselnum ='PS0_22200000002014112800158741'
and t1.clearcode=t3.clearcode
group by t1.paymoney, t1.paymadedate;