I have a table below

 first      second  

-------     ----------  

100        0  

200        0  

0           400  

I want to get below result

 first      second      result  

-------     ---------- ----------  

100        0            100  

200        0            300  

0           400         -100  

As you can see that result parameter is sum of previous (first-sum) How can i write such a query ?

MYSQL solution is very simple, but simple solutions are looking for Microsoft Sql Server.

set @result =0;  

select first, second, @result := @result + first - second as result  

from tablo;   

results

first  second  result