Sum

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

-- Remember that only God and Esc+:w saves.
__
(_.\ Marcelo Pereira |
/ / ___ marcelo(at)pereira(dot)com |
/ (_/ _ \__ [Math|99] - IMECC |
_______\____/_\___)___Unicamp_______________/