Subject | Re: [firebird-support] Re: RunSum in Firebird |
---|---|

Author | Helen Borrie |

Post date | 2008-07-30T13:42:27Z |

At 11:23 PM 30/07/2008, you wrote:

Let Halim explain what he wants to sum and what he hopes for as output.

./heLen

>I believe Halim is refering to the RUNSUM function found inThat's what he seemed to be saying but it is illogical. "Sum all the values in the specified column in a continuous running total" is nothing like the description you quote here.

>Elevatesoft DBISAM Database Engine:

>

>RUNSUM Function

>

>The RUNSUM function calculates the sum of values for a column in a

>running total. The syntax is as follows:

>

>RUNSUM(column_reference or expression)

>

>Use RUNSUM to sum all the values in the specified column in a

>continuous running total. The RUNSUM function is identical to the SUM

>function except for the fact that it does not reset itself when sub-

>totalling.

>

>If a query is ordered by price, RUNSUM(1) would provide a column that

>would sequentially number each row starting with 1 for the first row,

>2 for second, therefore providing a "rank" for your results (by price

>in the example).

Let Halim explain what he wants to sum and what he hopes for as output.

./heLen