累计汇总 用分析函数 select time endtime ,sum(count) over(order by time ) count from tb ;
SELECT T1.TIME,SUM(T2.COUNT) FROM TABLE1 T1,TABLE1 T2 WHERE T1.TIME >= T2.TIME GROUP T1.TIME
如果问题转换成: time count name 2009-01 100 a 2009-03 200 a 2009-08 200 a 2009-01 100 b 2009-03 200 b 2009-08 200 b 统计求出: endtime count name 2009-03 300 a 2009-08 500 a 2009-08 500 b
你这个结果没有明显的规律,为什么a有2009-03,b却没有呢?下面给出显示所有连续求和的算法 select time,name,sum(count) over(parttion by name order by name,time) from table
用分析函数
select time endtime
,sum(count) over(order by time ) count
from tb
;
FROM TABLE1 T1,TABLE1 T2
WHERE T1.TIME >= T2.TIME
GROUP T1.TIME
time count name
2009-01 100 a
2009-03 200 a
2009-08 200 a
2009-01 100 b
2009-03 200 b
2009-08 200 b
统计求出:
endtime count name
2009-03 300 a
2009-08 500 a
2009-08 500 b
你这个结果没有明显的规律,为什么a有2009-03,b却没有呢?下面给出显示所有连续求和的算法
select time,name,sum(count) over(parttion by name order by name,time) from table