SQL Explained: Grouping Sets, Rollup, and Cube | by Thomas Reid | May, 2024

What are they and how do you use them?

I am a long-time user of SQL, but something that I never quite got to grips with was the use of the grouping sets, cube, and rollup functionality that modern SQL database systems introduced a number of years ago.

Part of the reason for that was probably because of the type of databases I was…