当前位置: 代码迷 >> Oracle管理 >> 求一条累加数据的查询语句解决方案
  详细解决方案

求一条累加数据的查询语句解决方案

热度:75   发布时间:2016-04-24 05:46:07.0
求一条累加数据的查询语句
例如:
RQ                       ACount
2007-1-1           10
2007-1-2           8
2007-1-3           12
2007-1-4           5
....

如何查询得到:
2007-1-1           10
2007-1-2           18
2007-1-3           30
2007-1-4           35
....

------解决方案--------------------
select a.rq,(select sum(ACount) from test where rq <= a.rq) from
test test a
order by a.rq


------解决方案--------------------
select a.a,sum(b.b)
from test a,test b
where b.a <=a.a
group by a.a
order by a.a
或者
select a.rq,(select sum(ACount) from test where rq <= a.rq)
from test a
order by a.rq
------解决方案--------------------
SELECT RQ, SUM(ACount) OVER (ORDER BY RQ) AS TOTAL
FROM tablename
  相关解决方案