Classifying your results with GROUPING_ID
Details
| Title | Classifying your results with GROUPING_ID |
| Author | SQL and Database explained! |
| Duration | 3:13 |
| File Format | MP3 / MP4 |
| Original URL | https://youtube.com/watch?v=WHCxpifIIns |
🎵 Support the artists — buy the original for the best audio quality! 🎵
Description
Once you start unleashing the power of ROLLUP and CUBE with your GROUP BY syntax, it becomes more challenging to know which rows are aggregations, or sub totals or grand totals. The GROUPING_ID function solves this dilemma.
ROLLUP video: https://www.youtube.com/watch?v=5xq7BSkKAF8
Follow me!
blog: https://connor-mcdonald.com
twitter: https://twitter.com/connor_mc_d
The Podcast!
https://podcasts.apple.com/au/podcast/the-spoken-nerd/id1552316025
https://open.spotify.com/show/5dqVVftZhw0lu1fnX20TiP
Subscribe for new tech videos every week
Other social media channels here: https://linktr.ee/connor
Music: The Wine, The Cars, Ah! Montmartre! - Late Night Feeler
#sql #database
