with rollup

[Joseph Morgan]

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.

Joseph