本文介绍了SQLite:SELECT 语句中的累加器(总和)列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一张这样的桌子:
从表中选择值;
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 语句中的累加器(总和)列
发布评论