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


Good job! It's time to wrap things up.

  1. GROUP BY GROUPING SETS( ) works by creating the grouping levels provided explicitly within its parentheses.
  2. You can use a pair of empty parentheses ( ) to introduce a general average, sum, etc.
  3. The GROUPING SETS extension can be combined with COALESCE().
  4. You can use both ROLLUP and CUBE to create even more sophisticated grouping combinations.

Okay, how about a short quiz now?


Click Next exercise to continue.