Subject Re: [firebird-support] Re: RunSum in Firebird
Author Helen Borrie
At 11:23 PM 30/07/2008, you wrote:

>I believe Halim is refering to the RUNSUM function found in
>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-
>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).

That'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.

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