-- This causes a problem as ROLLUP adds a record even if it already exists in the data. For example: -- WITH A AS (SELECT NULL A FROM Dual), B AS (SELECT A FROM A GROUP BY ROLLUP(A)) SELECT Rownum, A FROM B