SQLite:SELECT 语句中的累加器(总和)列

2022-01-09 00:00:00 sql sum cumulative-sum sqlite accumulator

我有一张这样的桌子:

从表中选择值；

value
1
3
13
1
5

我想添加一个累加器列，这样我就有了这样的结果:

I would like to add an accumulator column, so that I have this result:

value  accumulated
1      1
3      4
13     17
1      18
5      23

我该怎么做?我想做的事情的真名是什么?谢谢

How can I do this? What's the real name of what I want to do? Thanks

推荐答案

试试这个方法:

select value,
(select sum(t2.value) from table t2 where t2.id <= t1.id ) as accumulated
from table t1

但如果它在您的数据库上不起作用，只需按一些东西添加顺序

but if it will not work on your database, just add order by something

select value,
(select sum(t2.value) from table t2 where t2.id <= t1.id order by id ) as accumulated
from table t1
order by id

这适用于 oracle ;) 但它也应该适用于 sqlite

this works on an oracle ;) but it should on a sqlite too

相关文章