Form:data
Time Amount
2015-01-01 10000
2015-01-02 20000
2015-01-03 30000
select a.时间,sum(b .Amount) as Cumulative amount
from data a,data b
< p>where a. time>=b. time
group by a. time
Form:data
Time Amount
2015-01-01 10000
2015-01-02 20000
2015-01-03 30000
select a.时间,sum(b .Amount) as Cumulative amount
from data a,data b
< p>where a. time>=b. time
group by a. time