Re: [firebird-support] Function - what is it called

2015-01-27 Thread Charles Hudson clh...@gmail.com [firebird-support]
In MS and Oracle dialects this would be accomplished with a ROLLUP or CUBE statement. On Tue, 2015-01-27 at 08:17 +1300, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > > At 11:25 p.m. 23/01/2015, michael.vilhelm...@microcom.dk > [firebird-support] wrote: > > >I am looking for a

Re: [firebird-support] Function - what is it called

2015-01-26 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 11:25 p.m. 23/01/2015, michael.vilhelm...@microcom.dk [firebird-support] wrote: >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

Re: [firebird-support] Function - what is it called

2015-01-23 Thread Mike Ro miker...@gmail.com [firebird-support]
On 23/01/2015 10:25, michael.vilhelm...@microcom.dk [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 prev

Re: [firebird-support] Function - what is it called

2015-01-23 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
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. > > >

[firebird-support] Function - what is it called

2015-01-23 Thread michael.vilhelm...@microcom.dk [firebird-support]
Hi I am looking for a function which are able to add values from a table as records are fetched. Something like this: Value Calculated value 1 1 2 3 3 6 4 10 5 15 The calculated value is just the sum of all previous values of VALUE. Whats the name of such function in engli