关于计算当年每个月年累计的SQL语句的写法

Question

例如有一个表的值为
month value

202001 6
202002 10
202003 9
202004 11
我想获得的结果为
month value
202001 6
202002 16
202003 25
202004 36

那么这个SQL应该怎么写呢

Answer 1

select b.month,sum(a.value) as value from table a, table b where a.month <= b.month group by b.month;