Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Jim MartinezDate: 2002-03-28 17:43:21
Subject: Re: Sum
Previous:From: Matthew KirkwoodDate: 2002-03-28 17:37:43
Subject: Re: Performance Tuning Document?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group