I have the following table:

I would like to create the following extra column 'TotalSum(Tickets)' but I am stuck....
Anyone who can help out?

CodePudding user response：

left join the same table where date is not bigger, then sum that for every date:

select 
    table1.date, 
    sum(t.tickets) 
from 
    table1 
        left join table1 t 
        on  t.date<= table1.date 
group by
    table1.date;

CodePudding user response：

You may use SUM() as a window function here:

SELECT A, SumTickets, SUM(SumTickets) OVER (ORDER BY A) AS TotalSumTickets
FROM yourTable
ORDER BY A;

But this assumes that you actually have a bona-fide column SumTickets which contains the sums. Assuming you really showed us the intermediate result of some aggregation query, you should use:

SELECT A, SUM(Tickets) AS SumTickets,
          SUM(SUM(Tickets)) OVER (ORDER BY A) AS TotalSumTickets
FROM yourTable
GROUP BY A
ORDER BY A;