SQLite：SELECT语句中的累加器（求和）列 [英] SQLite: accumulator (sum) column in a SELECT statement

问题描述

我有一张这样的表：

从表中选择值；

SELECT value FROM table;

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

这篇关于SQLite：SELECT语句中的累加器（求和）列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！