On 23/01/2015 10:25, [email protected] [firebird-support] wrote:

Hi


I am looking for a function which are able to add values from a table as records are fetched.

Something like this:


ValueCalculated value

11

23

36

410

515

The calculated value is just the sum of all previous values of VALUE.

Whats the name of such function in english and Firebird?

This is sometimes called the Triangular Number, see

http://en.wikipedia.org/wiki/Triangular_number

Reply via email to