TalkPHP - View Single Post

delayedinsanity · 11-01-2009, 07:12 PM

I thought I understood that ROLLUP used in conjunction with a GROUP BY clause is supposed to produce an additional row which sums up the data selected.

However, in one such instance, these are the results I'm getting;

Code:

2009-10-31   |   8   |   14
2009-11-01   |  72   |  149
NULL         |  78   |  163

The third column is totaled correctly, but the second is very obviously not. Double U Tee Eff? I think I'm missing something...

11-01-2009, 07:12 PM	#1 (permalink)
delayedinsanity is cute and cuddly Join Date: Mar 2008 Location: Vegas, Baby Posts: 963 Thanks: 31	WITH ROLLUP producing unexpected results I thought I understood that ROLLUP used in conjunction with a GROUP BY clause is supposed to produce an additional row which sums up the data selected. However, in one such instance, these are the results I'm getting; Code: 2009-10-31 \| 8 \| 14 2009-11-01 \| 72 \| 149 NULL \| 78 \| 163 The third column is totaled correctly, but the second is very obviously not. Double U Tee Eff? I think I'm missing something...