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
Summary
16. Summary

Instruction

Great! It’s time to wrap things up.

  1. GROUP BY CUBE () creates all possible grouping combinations with the columns inside its parentheses.
  2. The order of columns within the parentheses of CUBE doesn't matter.
  3. You can use GROUPING_ID() with the same columns as those in the GROUP BY CUBE () clause to get grouping level IDs.
  4. You can leave some columns outside CUBE. Such columns will always be used for grouping.
  5. You can use additional pairs of parentheses inside CUBE to indicate that certain columns should be treated as a single column by the CUBE clause.
  6. You can use COALESCE() to replace NULL values with something more meaningful.

How about a short quiz now?

Exercise

Click Next exercise to continue.