连前统计有关问题
连前统计问题
有表A:
A B
100 1
101 2
102 3
104 1
105 1
要求得出:
A B C
100 1 1
101 2 3
102 3 6
104 1 7
105 1 8
------解决方案--------------------
VFP9:
SELECT *,(SELECT SUM(B) FROM TT WHERE A.A> =A) AS C FROM TT A
有表A:
A B
100 1
101 2
102 3
104 1
105 1
要求得出:
A B C
100 1 1
101 2 3
102 3 6
104 1 7
105 1 8
------解决方案--------------------
VFP9:
SELECT *,(SELECT SUM(B) FROM TT WHERE A.A> =A) AS C FROM TT A