Introduction
1. Introduction
GROUP BY – Recap
ROLLUP
Summary

Instruction

Welcome! The aim of this course is to teach you how to use various GROUP BY extensions: ROLLUP, CUBE, and GROUPING SETS. They are often used to create advanced reports with SQL.

We assume that you already know a lot of SQL and can put that knowledge into practice. In particular, you know how to group rows by single or multiple columns and how to calculate aggregate functions: sums, averages, maximal values, etc.