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.
