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 MS SQL Server

Introduction
1. Introduction
GROUP BY – Recap
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.

So, are you ready?

Exercise

Click Next exercise to continue.