Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

GROUP BY Extensions in MS SQL Server

Introduction
CUBE
Summary

Instruction

Just like ROLLUP, CUBE can also be used with GROUPING_ID() to get numerical IDs for each grouping level:

SELECT
  GROUPING_ID(Location, Gender, Risk) AS GroupingId,
  Location,
  Gender,
  Risk,
  AVG(Efficacy) AS AvgEfficacy
FROM VaccineAdministration
GROUP BY 
  CUBE (Location, Gender, Risk);

Let’s see what happens.

Exercise

Run the template query and note how many GROUPING_ID() values are created.