...
Going back to our example above, consider the following query: SELECT
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT key, value, GROUPING__ID, grouping(key, value), |
...
grouping(value, key), |
...
grouping(key), grouping(value), count(*) |
...
FROM T1 GROUP BY key, value WITH ROLLUP; |
This query will produce the following results.
...