Accumulated sums in SQL query

From: "Kabai Jzsef" <kabai(at)audiobox(dot)hu>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Accumulated sums in SQL query
Date: 2002-10-28 08:13:56
Message-ID: 006101c27e5a$08153840$6b01a8c0@audiobox.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
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

Thanks in advance
Regards, Joseph

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2002-10-28 08:20:31 Re: Accumulated sums in SQL query
Previous Message Josh Berkus 2002-10-27 19:49:16 Re: datediff?