SELECT a, b, SUM(c) FROM tab1 GROUP BY a, b GROUPING SETS ( (a,b) )
| SELECT a, b, SUM(c) FROM tab1 GROUP BY a, b
|
SELECT a, b, SUM( c ) FROM tab1 GROUP BY a, b GROUPING SETS ( (a,b), a)
|
-
SELECT a, b,
SUM( c )
FROM tab1
GROUP
BY a, b
-
-
SELECT a,
null,
SUM( c )
FROM tab1
GROUP
BY a
|
SELECT a,b, SUM( c ) FROM tab1 GROUP BY a, b GROUPING SETS (a,b)
|
-
SELECT a,
null,
SUM( c )
FROM tab1
GROUP
BY a
-
-
SELECT
null, b,
SUM( c )
FROM tab1
GROUP
BY b
|
SELECT a, b, SUM( c ) FROM tab1 GROUP BY a, b GROUPING SETS ( (a, b), a, b, ( ) )
|
-
SELECT a, b,
SUM( c )
FROM tab1
GROUP
BY a, b
-
-
SELECT a,
null,
SUM( c )
FROM tab1
GROUP
BY a,
null
-
-
SELECT
null, b,
SUM( c )
FROM tab1
GROUP
BY
null, b
-
-
SELECT
null,
null,
SUM( c )
FROM tab1
|