Adding new Column containing values based on condition

[dacopan]

you can achive it by using over window function

SELECT Id, DailyPoduction,
SUM (DailyPoduction) OVER (ORDER BY Id) AS CummulativePoduction
FROM MY_TABLE