Subject | Re: RunSum in Firebird |
---|---|

Author | Halim B |

Post date | 2008-07-30T01:21:54Z |

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. We used 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.

in my case I use RunSum(1), combined with order by I get exactly what I

need to rank my rows.

-Halim

running total. The syntax is as follows:

RUNSUM(column_reference or expression. We used 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.

in my case I use RunSum(1), combined with order by I get exactly what I

need to rank my rows.

-Halim