在SQL中,您可以使用ANSI标准
sum() over ()功能进行累加总和:
select classes, id, value, sum(value) over (partition by classes order by id) as cumesumfrom t;

在SQL中,您可以使用ANSI标准
sum() over ()功能进行累加总和:
select classes, id, value, sum(value) over (partition by classes order by id) as cumesumfrom t;