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

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

GROUP BY Extensions in PostgreSQL

Introduction
1. Introduction
GROUP BY – Recap
Summary

Instruction

Welcome! This course aims to teach you how to use various GROUP BY extensions: ROLLUP, CUBE, and GROUPING SETS. They are often used to create advanced reports with PostgreSQL.

These extensions to the GROUP BY clause have been added to the ANSI/ISO standard SQL:1999, but they have been available in PostgreSQL since version 9.6.

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

So, are you ready?

Exercise

Click Next exercise to continue.