> 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