计算前一个单元格的SUM(VALUE)

Question

我有以下表格:

<表类> (票)和tbody><<tr>01 - 2022502 - 2022203 - 2022804 - 2022105 - 2022306 - 2022307 - 2022408 - 2022109 - 2022510 - 2022511 - 20223

您可以在这里使用SUM()作为窗口函数:

SELECT A, SumTickets, SUM(SumTickets) OVER (ORDER BY A) AS TotalSumTickets
FROM yourTable
ORDER BY A;

但是这里假设您实际上有一个包含总和的真实列SumTickets。假设您确实向我们展示了一些聚合查询的中间结果，您应该使用:

SELECT A, SUM(Tickets) AS SumTickets,
SUM(SUM(Tickets)) OVER (ORDER BY A) AS TotalSumTickets
FROM yourTable
GROUP BY A
ORDER BY A;

左连接同一个表，如果日期不大于，则对每个日期求和:

select 
table1.date, 
sum(t.tickets) 
from 
table1 
left join table1 t 
on  t.date<= table1.date 
group by
table1.date;