Learn about GROUP BY Extensions in SQL Server - CUBE, ROLLUP, and GROUPING SETS | Online Course | Vertabelo Academy

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

Well done! You learned about yet another powerful GROUP BY extension.

Judging by the progress you’ve made, we’re confident that this final quiz will be a piece of cake for you. Ready to take on the challenge?

18/18 Congratulations

1. Introduction

2. Get to know the WarrantyRepair table

3. Get to know the Loan table

4. Multiple grouping with UNION ALL

5. Multiple grouping with UNION ALL – practice

6. Multiple groupings with GROUPING SETS

7. Multiple groupings with GROUPING SETS – practice

8. Using an empty grouping set

9. Using an empty grouping set – practice

10. GROUPING SETS with GROUPING_ID

11. GROUPING SETS with GROUPING()

12. GROUPING SETS with COALESCE()

13. GROUPING SETS with ROLLUP and CUBE

14. GROUPING SETS with ROLLUP and CUBE – practice

18. Congratulations

You nailed it! There are no exercises left in this section.

You now know how to use all three GROUP BY extensions: ROLLUP, CUBE, and GROUPING SETS. Congratulations!

Click Next exercise to finish this part.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.