Explain ROLLUP and CUBE.
Skip to solutionKEEP THE
mediumDSA
What do GROUP BY ROLLUP and CUBE do?
60 views
01
Understand the problem
group-by-rollup
02
Attempt it yourself
Sketch your approach before reading the solution — that's what interviews test.
Nudge consolestandby
Stuck? Beam a request up — the console returns a conceptual nudge that guides your logic without spoiling the implementation.
03
Study the solution
ROLLUP adds subtotal and grand-total rows along a hierarchy of grouping columns; CUBE produces subtotals for all combinations of them. They generate summary rows (with NULL group keys) for reporting without multiple UNION queries.
Solution ready — 2 min read
Classified // press E to declassify
04
Run the code
SQLROLLUP Simulation Playground
05
Join the discussion
Discussion (0)
Sign in to join the discussion.
No responses yet. Be the first to share what you think.
Transmission complete // awaiting log
KEEP THE
STREAK ALIVE.
Dossier 49 of 70 decoded in the SQL track. One more won't hurt.