Subject | Re: [firebird-support] Function - what is it called |
---|---|
Author | Thomas Steinmaurer |
Post date | 2015-01-23T10:28:30Z |
Hello Michael,
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
> I am looking for a function which are able to add values from a table asCumulative sum?
> records are fetched.
> Something like this:Window function
>
>
> 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?
> 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.