What does GROUP BY CUBE(dept, role) produce compared to ROLLUP?

Question

SQL Data Analyst — Medium

What does GROUP BY CUBE(dept, role) produce compared to ROLLUP?

Accepted Answer

GROUP BY CUBE(dept, role) produces aggregates for all possible combinations of dept and role, including (dept,role), (dept), (role), and (); whereas ROLLUP only produces a hierarchical subset.