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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
