表a字段cdate count
2011-06-01 1
2011-06-02 1
2011-06-03 1
2011-06-04 1
2011-06-05 1需要统计结果
2011-06-01 1
2011-06-02 2
2011-06-03 3
2011-06-04 4
2011-06-05 5
2011-06-01 1
2011-06-02 1
2011-06-03 1
2011-06-04 1
2011-06-05 1需要统计结果
2011-06-01 1
2011-06-02 2
2011-06-03 3
2011-06-04 4
2011-06-05 5
FROM test A
cdate
2011-06-01
2011-06-02
2011-06-03
2011-06-04
2011-06-05表2
cdate count
2011-06-01 1
2011-06-02 2
2011-06-03 1
2011-06-05 5
即 汇总所有日期内的合计,按日期分组,
要求:某日合计包含该日及小于该日的合计
以上数据,合计2011-06-01至2011-06-10 要求得到如下结果
cdate count
2011-06-01 1
2011-06-02 3
2011-06-03 4
2011-06-04 4
2011-06-05 9
2011-06-06 9
2011-06-07 9
2011-06-08 9
2011-06-09 9
2011-06-10 9
(SELECT SUM(count) FROM B2 WHERE B2.cdate<=B1.cdate) FROM B1 A