有一张表如下:字段: aaa bbb date
记录: 10 10 2008-01-01
10 20 2008-01-02
10 30 2008-01-03
20 50 2008-01-04
20 70 2008-01-05说明:本天bbb值=等于上一天的bbb值+本天的aaa值,急求批量更新的sql写法,例如更新2008-01-03以后的,谢谢!
记录: 10 10 2008-01-01
10 20 2008-01-02
10 30 2008-01-03
20 50 2008-01-04
20 70 2008-01-05说明:本天bbb值=等于上一天的bbb值+本天的aaa值,急求批量更新的sql写法,例如更新2008-01-03以后的,谢谢!
set bbb = aaa + (select bbb from table where date+1=A.date)
WHERE A.DATE>TO_DATE('2008-01-03','YYYY-MM-DD');