Classifying your results with GROUPING_ID

Details

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