er 28, 2002 1:27 PM
: Subject: Re: [SQL] Accumulated sums in SQL query
:
:
: > >
: > > OK I have a table named bank_account_movements containing two columns
: > =
: > > date and amount:
: > >
: > > date amount (in USD)
: > > ---
Thank you Christoph this logic helped me a lot.
Regards Joseph
- Original Message -
From: "Christoph Haller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 28, 2002 1:27 PM
Subject: Re: [SQL] Accumulated sums in SQL
>
> OK I have a table named bank_account_movements containing two columns
=
> date and amount:
>
> date amount (in USD)
> -
> 2002-10-01 20
> 2002-10-02 30
> 2002-10-03 -15
> 2002
2
57
-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
> Which is the simplest way to create an SQL query to get accumulated
sums of
> records like this (from the table containing the numbers):
>
> numbersums
> ---
> 1 1
> 2 3
> 3 6
> 4 10
>
SELECT number, SUM(your_sum_column) FROM
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):
numbersums
---
1 1
2 3
3 6
4 10
Thanks in advance
Regards, Joseph
