Image by AI (Dalle-3)

SQL Explained: Grouping Sets, Rollup, and Cube

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…