这样可以吧。先给记录排序加个字段,不能间断
dATE W_Amount M_Remain OrderField
2003-09 0 0 1
2003-10 1 2 2
2003-11 4 5 3
2003-12 5 8 4
2004-01 8 22 5
其中OrderField(1、2、3、4、5不能间断)
select dATE,
W_Amount=(select a.W_Amount-b.W_Amount from tbl b where b.OrderField=a.OrderField-1 ),
M_Remain=(select a.M_Remain-c.M_Remain from tbl c where c.OrderField=a.OrderField-1 )
from tbl a where a. OrderField >1