Re: Sum

From: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To: Marcelo Pereira <gandalf(at)sum(dot)desktop(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sum
Date: 2002-03-28 17:40:10
Message-ID: 3CA3557A.B6957EA6@nsd.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marcelo,

Assuming that "cod" is unique and sequencial, you can use the following:

SELECT *, ( SELECT SUM( value) from table as t2 where t2.cod <= t1.cod)
as running_total
FROM table as t1
ORDER BY cod;

jll

Marcelo Pereira wrote:
>
> Hello All,
>
> I have a single table as:
>
> cod date value
> ---+-------------+-------
> 1 | 2002-03-12 | 5
> 2 | 2002-03-13 | 4
> 3 | 2002-03-13 | 7
> 4 | 2002-03-14 | 3
>
> ... and I would like to do a select that do `partial sums'.
>
> So, for instance, I would like to do a select that returns:
>
> cod date value partial sum
> ---+-------------+-------+--------------
> 1 | 2002-03-12 | 5 | 5
> 2 | 2002-03-13 | 4 | 9
> 3 | 2002-03-13 | 7 | 16
> 4 | 2002-03-14 | 3 | 19
>
> As you can see, the row `partial sum' is what I am looking for. Do you
> have any idea how can I do it?
>
> Thanks in advance,
>
> Marcelo Pereira

In response to

  • Sum at 2002-03-28 17:15:49 from Marcelo Pereira

Responses

  • Re: Sum at 2002-03-28 17:43:21 from Jim Martinez
  • Re: Sum at 2002-03-28 17:45:56 from Marcelo Pereira

Browse pgsql-general by date

  From Date Subject
Next Message Jim Martinez 2002-03-28 17:43:21 Re: Sum
Previous Message Matthew Kirkwood 2002-03-28 17:37:43 Re: Performance Tuning Document?