Cube

Stairway to T-SQL DML

Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause

  • Stairway Step

In this article I will be expanding on my discussion of the GROUP BY clause by exploring the ROLLUP, CUBE and GROUPING SETS operators. These additional GROUP BY operators make it is easy to have SQL Server create subtotals, grand totals, a superset of subtotals, as well as multiple aggregate groupings in a single SELECT statement.

2012-08-22

17,322 reads

Blogs

Daily Coping 29 Nov 2022

By

Today’s coping tip is to make a meal using a recipe or ingredient you’ve...

My adventures with speaking and what changed

By

I am writing this blog post as contribution to #NewStarNovember and what got me...

Automatically Take Missed Backups with Ola Hallengren’s Scripts

By

I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance...

Read the latest Blogs

Forums

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Assigning a Server Role

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Assigning a Server Role

Cloud First Software

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud First Software

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers