I have this:
UPDATE MONEY SET Balance = Credit - Debit + "X"
Ok, that "X" is supposed to be the prior row. I need to calculate the Balance, which is the result of the previous balance + the result of credit + debit. The thing is by the nature of our business we need to alter some old rows and recalculate the balance. The update works that way? How to get the value for a column in the previous row?