Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
15. 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 both GROUPING_ID and 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.