fid, fqty, fsumqty-------------------------------------
1, 10, 12.30 //1的fsumqty初始值為12.30
2, 12, 24.30 //2的fsumqty=12.30+12=24.30
3, 8, 22.30 //3的fsumqty =24.30+8= 22.30
4.....
.
.
.
如何在SQL裡實現一條記錄的fsumqty值為上一條記錄的fsumqty值加上本條記錄fqty字段值?
不用遊標行不行?
1, 10, 12.30 //1的fsumqty初始值為12.30
2, 12, 24.30 //2的fsumqty=12.30+12=24.30
3, 8, 22.30 //3的fsumqty =24.30+8= 22.30
4.....
.
.
.
如何在SQL裡實現一條記錄的fsumqty值為上一條記錄的fsumqty值加上本條記錄fqty字段值?
不用遊標行不行?
SET t.fsumqty = s.fsumqty + t.fqty
FROM table1 t, (select fid, fsumqty from table1) s
WHERE (t.fid >1) and (s.fid=t.fid-1)