Re: Accumulated sums in SQL query

Thanks, but it seems not to be the solution to me, the example was not good enough. The table for example represents a bank account, 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(at)rodos(dot)fzk(dot)de>
To: <kabai(at)audiobox(dot)hu>
Cc: <pgsql-sql(at)postgresql(dot)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
>