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
group by a. time
Tag: accumulation
PostgreSQL – Postgres – Calculation of cumulative data
I collect data from some API sources through Python and add it to 2 tables in Postgres.
Then, I use this data To generate reports, join and group/filter data. I add thousands of rows every da