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@pereira.com |
/ (_/ _ \__ [Math|99] - IMECC |
_______\____/_\___)___Unicamp_______________/
