Do you want to perform multiple groupings in one query? Learn how to use GROUP BY extensions, such as ROLLUP in MySQL. Take the next step towards being a SQL expert!
Do you already know the basics of SQL? Then It’s time to learn some of its advanced features! In this online MySQL course, you’ll learn how to use the GROUP BY extensions. This includes WITH ROLLUP, which allows you to do multiple groupings with one query. If you are serious about a career in data analytics, business development, or anything that requires data analysis, you should know about these features.
WITH ROLLUP is a super-handy extension of the GROUP BY clause. It allows you to attach additional lines which represent subtotals. They are often called super-aggregated rows, and they can be presented together with the total sum line. Thanks to this, you can generate multiple grouping sets using just one SQL query.
This online MySQL course is intended for intermediate SQL users. If you are new to MySQL, take SQL Basics in MySQL first and come back here for more.
GROUP BY Extensions in MySQL is interactive. Everything happens in the online console. You practice by writing real SQL code and solving exercises directly in your web browser. Our online platform runs your code and verifies your solution. You don't need to install any software on your computer.
This course uses MySQL 8. However, anyone working with MySQL 5 and earlier can also take the course; we clearly indicate which GROUP BY extension features are only available in MySQL 8.
Learn how to use ROLLUP with GROUP BY.