select t.月份, (select sum(值) from 表A where 月份<=t.月份)+t.附加值 as 总值 from 表A as t或者select m.月份,sum(n.值)+m.附加值 as 总值 from 表A m, 表A n where m.月份>=n.月份 group by m.月份,m.附加值
谢谢 libin_ftsafe(子陌红尘:当libin告别ftsafe) 。 成功执行。
select t.月份, sum(值)over(ORDER BY t.月份)+ t.附加值 as 总值 from 表A as t
select t.月份, sum(值)over(ORDER BY t.月份 ROWS UNBOUNDED PRECEDING)+ t.附加值 as 总值 from 表A as t
t.月份,
(select sum(值) from 表A where 月份<=t.月份)+t.附加值 as 总值
from
表A as t或者select
m.月份,sum(n.值)+m.附加值 as 总值
from
表A m,
表A n
where
m.月份>=n.月份
group by
m.月份,m.附加值
。
成功执行。
sum(值)over(ORDER BY t.月份)+ t.附加值 as 总值
from 表A as t
sum(值)over(ORDER BY t.月份 ROWS UNBOUNDED PRECEDING)+ t.附加值 as 总值
from 表A as t