Skip to content

Instantly share code, notes, and snippets.

@andrewscaya

andrewscaya/grouping_sets.sql

Created November 4, 2016 19:49
Show Gist options
  • Save andrewscaya/945c69b0666791cfee1ade1b89deeea1 to your computer and use it in GitHub Desktop.
Save andrewscaya/945c69b0666791cfee1ade1b89deeea1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
grouping_sets.sql
SELECT
day,
month,
year,
sum(total)
FROM
revenue
GROUP BY GROUPING SETS (
(day, month, year),
(month, year),
(year)
);
Raw
original_rollup.sql
SELECT
day,
month,
year,
sum(total)
FROM
revenue
GROUP BY
day, month, year
UNION
SELECT
NULL,
month,
year,
sum(total)
FROM
revenue
GROUP BY
month, year
UNION
SELECT
NULL,
NULL,
year,
sum(total)
FROM
revenue
GROUP BY
year
Raw
rollup.sql
SELECT
day,
month,
year,
sum(total)
FROM
revenue
GROUP BY ROLLUP(day, month, year);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment