THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Table 1 - GROUPING SET queries and the equivalent GROUP BY queriesSet A -
B2. SELECT a, b, SUM( c ) FROM tab1 GROUP BY a, b UNION
Aggregate Query with GROUPING SETS |
|---|
...
Equivalent Aggregate Query with GROUP BY |
|---|
...
SELECT a, b, SUM(c) FROM tab1 GROUP BY GROUPING SETS ( (a,b) ) |
...
SELECT a, b, SUM(c) FROM tab1 GROUP BY a, b |
...
SELECT a, b, SUM( c ) FROM tab1 GROUP BY GROUPING SETS ( (a,b), a) |
...
SELECT a, b, SUM( c ) FROM tab1 GROUP BY a, b |
...
UNION SELECT a, null, SUM( c ) FROM tab1 GROUP BY a |
...
SELECT a,b, SUM( c ) FROM tab1 GROUP BY GROUPING SETS (a,b) |
...
SELECT a, null, SUM( c ) FROM tab1 GROUP BY a |
...
SELECT a, b, SUM( c ) FROM tab1 GROUP BY GROUPING SETS ( (a, b), a, b, ( ) ) |
...
SELECT a, b, SUM( c ) FROM tab1 GROUP BY a, b UNION | |
|
|