with rollup

[Ruslan Zasukhin]

On 28/10/07 5:06 PM, "Joseph Morgan" <joseph at checkos.com> wrote:

> 
> On Oct 28, 2007, at 5:01 AM, Bart Pietercil wrote:
> 
>> could you please explain what the difference is between "WITH
>> ROLLUP" and SUM(somefield) ?
> 
> I should have typed group by with rollup.
> Take the following for example:
> 
> select sum(f1) as fSUM1,sum(f2) as fSUM2,sum(f3) as fSUM3 group by
> customeNameField with rollup
> 
> fSUM1 fSUM2 fSUM3
> cust 1 5  10  11
> cust2 10  10  5
> cust3 11  11  11
> 26  31  27 <<<<<this is with rollup
> 
> Lists sums for each field grouped but then adds the grouped sums to
> the end of the cursor.

Right.

    WITH ROLLUP  -- adds kind of TOTAL for each group.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]