Re: Accumulated sums in SQL query - Mailing list pgsql-sql

> Which is the simplest way to create an SQL query to get accumulated
sums of
>  records like this (from the table containing the numbers):
>
> number    sums
> ---------------
> 1               1
> 2               3
> 3               6
> 4              10
>
SELECT number, SUM(your_sum_column) FROM your_table
GROUP BY number ;

Regards, Christoph