Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
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.