Subject Re: [firebird-support] Function - what is it called
Author Thomas Steinmaurer
Hello Michael,

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

Cumulative sum?

> 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?

Window function

> Does such a function even exist in Firebird 2.5?

No. Firebird 3.0 will have them.



--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.