Thanks, but it seems not to be the solution to me, the example was not good enough. The table for example represents a
bankaccount, records are debits and credits, and I need the balance in the new query:
D&C balance
---------------
1 1
3 4
-2 2
5 7
-3 4
3 7 and so on
regards Joseph
----- Original Message -----
From: "Christoph Haller" <ch@rodos.fzk.de>
To: <kabai@audiobox.hu>
Cc: <pgsql-sql@postgresql.org>
Sent: Monday, October 28, 2002 9:20 AM
Subject: Re: [SQL] Accumulated sums in SQL query
> > 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
>
