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)