• select date_value,monthly_total,(select sum(monthly_total) from sales s where date_value <= tst.date_value )

    monthly_total_sum from

    (

    select *,ROW_NUMBER() over ( order by date_value )tst from sales

    )tst order by date_value