11-01-2009, 07:12 PM
|
#1 (permalink)
|
|
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... |
|
|
|
Join the friendly bunch on IRC...
Linear Mode
