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


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 the GROUPING() function to show if the column is included in the grouping.
  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?


Click Next exercise to continue.