sql科目余额计算
jf(借方) df(贷方) index sj(时间) yr(余额)
0.0000 3741294.2400 10 0000-00-00 (3741294.2)(期初)
269099499.9400 0.0000 12 0000-00-00 265358205.7 (期初)
0.0000 5015906.2400 4 2007-01-10 260342299.5 (期初+(jf-df))
0.0000 5346362.7200 5 2007-01-10 254995936.7
0.0000 130340000.0000 2 2007-01-15 124655936.7
144533100.0000 0.0000 2 2007-01-16 269189036.7
130340000.0000 0.0000 1 2007-01-22 399529036.7
34865.4300 0.0000 2 2007-01-22 399563902.2
0.0000 144430840.2000 3 2007-01-22 255133062.0
0.0000 255170000.0000 3 2007-01-22 (36938.0)
258476500.0000 0.0000 2 2007-01-23 258439562.0
0.0000 256482355.8000 3 2007-01-29 1957206.2
255170000.0000 0.0000 3 2007-01-29 257127206.2
0.0000 102259.8000 4 2007-01-29 257024946.4
88232.2600 0.0000 4 2007-01-29 257113178.6
0.0000 273162.3900 5 2007-01-29 256840016.2
9887370.0000 0.0000 1 2007-01-31 266727386.2
今天碰到用sql计算科目余额的问题,有没有高手写一个,根据前面的贷方,借方,期初,算出当天的余额。谢谢