Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Summary
14. Summary

Instruction

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?

Exercise

Click Next exercise to continue.