GROUPING SETS / ROLLUP / CUBE?!

ROLLUP creates MULTIPLE grouping levels! It generates subtotals and grand totals automatically. This one query returns MANY result sets!

#sql #sqltricks #rollup #cube #groupingsets #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql

https://www.youtube.com/watch?v=C35N6p1rooE

GROUPING SETS ROLLUP CUBE?! #codingchallenge

YouTube

Spark SQL for Data Engineering 22: Advanced Group By Grouping Sets Cube Rollup #Cube #rollup #sql

Spark SQL for Data Engineering 22: Advanced Group By Grouping Sets Cube Rollup #Cube #rollup #sql #groupingSets ... source

https://quadexcel.com/wp/spark-sql-for-data-engineering-22-advanced-group-by-grouping-sets-cube-rollup-cube-rollup-sql/

Spark SQL for Data Engineering 22: Advanced Group By Grouping Sets Cube Rollup #Cube #rollup #sql - QuadExcel.com

Spark SQL for Data Engineering 22: Advanced Group By Grouping Sets Cube Rollup #Cube #rollup #sql #groupingSets ... source

QuadExcel.com