rollup not working
Date: Wed, 25 Feb 2004 19:02:29 -0500
Message-ID: <1KednaVlHdAXqqDdRVn-gw_at_magma.ca>
Am looking at an Oracle SQL reference book.
They have the following SQL for ROLLUP which works
SELECT 0.YEAR, TO_CHAR(TO_DATE(O.MONTH, 'MM'), 'Month') MONTH,
R.NAME REGION, SUM(O.TOT_SALES)
FROM ORDERS O, REGION R
WHERE R.REGION_ID = O.REGION_ID
AND O.MONTH BETWEEN 1 AND 3
Why is this happening?
Note that the only difference is that O.YEAR is now outside the ROLLUP
SELECT O.YEAR, TO_CHAR(TO_DATE(O.MONTH, 'MM'), 'Month') MONTH,
R.NAME REGION, SUM(O.TOT_SALES) FROM ORDERS O, REGION R WHERE R.REGION_ID = O.REGION_ID AND O.MONTH BETWEEN 1 AND 3 GROUP BY O.YEAR, O.MONTH ROLLUP (R.NAME) Received on Thu Feb 26 2004 - 01:02:29 CET