[Solved] How to calculate cumulative values in queries

[gkick]

Hi,

based on a transaction table I would like to display a chart showing cumulative income and expense
values. No idea how to go about it

the query in mind would look like the image below
For the chart I only would need the cum values for any given month end

Anyone having an example of cum s in sql ?

Thanks

[FJCC]

Here is one method.

Code: Select all

SELECT t1.id, t1.income, t1.expense, SUM(t2.income) AS Cum_Income, SUM(t2.expense) AS Cum_Exp
FROM Money t1 INNER JOIN Money t2 ON t1.id >= t2.id
GROUP BY t1.id, t1.income, t1.expense

[gkick]

That's great, thank you so much!!!