SubTotals with SQL using ROLLUP

Demonstration of the group by subclause rollup.

[@gulammohiddin5747]

Something new I learnt today. I wish I found this channel a few years ago. These videos are amazing tutorials.

[@32oel]

Thanks, good explanation, didn't know about the Rollup option!

[@mmontaldo-yt]

Hi James, first of all I'd like to thank you for your content, I always find it very useful. I was wondering if you could recommend some book about microstrategy and/or Business Intelligence and Business analytics. Thanks again!

[@tableaututorialstips71]

Very Nice video :) tnx for sharing this

[@anuragbawankar685]

Thanks James !!!

[@badda_boom8017]

hmmm I dont seem to have that table in my DB. I am using 2017... Is this one which you have created? I would like to follow along.
Thanks :)

[@richwalter5322]

Awesome

[@JamesOliver]

Thanks bud.

[@143sudesh]

Awesome video.but how to display text of TOTAL instead of NULL .
It will be very help full to recognise .

[@teekay3747]

Step one is googling the meaning of aggregate