A means to retrieve multi-level aggregation metrics in a single query...
Call it premonition or just my curiosity, but for whatever reason, I have been studying - of my own accord - the WITH ROLLUP modifier for the MySQL GROUP BY clause.
Having never used WITH ROLLUP in any queries in real-world projects, I still found it quite interesting as a means to retrieve multi-level aggregation metrics in a single query.
And so, some amount of time passed…
Lo and behold I would need this functionality sooner than I anticipated for a query requirement so kudos to my curious persistence!
Nevertheless, what does GROUP BY WITH ROLLUP do?
That is what we are going to learn about in this post using some simple exploratory queries and examples.
Read the entire article over in the OpenLampTech publication...
Top comments (0)