> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org