A homework assignment I have asks the following question:
Show how to express \group by cube (a, b, c, d)" using rollup rather than cube.
I really don't have the faintest clue how to do this. Where would I start or where could I look for some help?
+2
A:
Hi Doug,
Since this is an assignment I will point you to a very good article about GROUP BY, ROLLUP and CUBE by Rob van Wijk.
Vincent Malgrat
2010-02-25 17:35:06
Ok, so after reading that... here's my proposed solution. Not sure if it's correct.group by rollup(a, b, c, d, ab, ac, ad, bd, cd)Would this work?
Doug
2010-02-25 17:47:17