GROUP BY Extensions in MS SQL Server

Table of contents

1. 1. ROLLUP

   0/23

   Learn how to use ROLLUP with GROUP BY.

   List of exercises Start now
   1. Introduction
      1. Introduction
   2. GROUP BY – Recap
      1. Get to know the tables – ContestScore
      2. Get to know the tables – Delivery
      3. Grouping by a single column
      4. Grouping by multiple columns
   3. ROLLUP
      1. ROLLUP introduction
      2. ROLLUP introduction – exercise
      3. Order of columns in ROLLUP
      4. Order of columns in ROLLUP – exercise
      5. The GROUPING_ID() function
      6. Function GROUPING_ID() – exercise
      7. The GROUPING() function
      8. The GROUPING() function – exercise
      9. Columns outside ROLLUP
      10. Columns outside ROLLUP – exercise
      11. Multiple ROLLUPs
      12. Multiple ROLLUPs – exercise
      13. ROLLUP with COALESCE()
      14. ROLLUP with COALESCE – exercise
   4. Summary
      1. Summary
      2. Exercise 1
      3. Exercise 2
      4. Congratulations

2. 2. CUBE

   0/19

   Discover CUBE, another GROUP BY extension.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. Get to know the tables – VaccineAdministration
      3. Get to know the tables – WildfireIncident
   2. CUBE
      1. Introduction to CUBE
      2. Introduction to CUBE – exercise
      3. Order of Columns in CUBE
      4. CUBE with GROUPING_ID()
      5. CUBE with GROUPING_ID() – exercise
      6. CUBE with GROUPING() – exercise
      7. Columns outside CUBE
      8. Columns outside CUBE – exercise
      9. CUBE with multiple pairs of parentheses
      10. CUBE with multiple pairs of parentheses – exercise
      11. CUBE with COALESCE()
      12. CUBE with COALESCE() – exercise
   3. Summary
      1. Summary
      2. Exercise 1
      3. Exercise 2
      4. Congratulations

3. 3. GROUPING SETS

   0/18

   Let's take a close look at GROUPING SETS, the last GROUP BY extension in our course.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. Get to know the WarrantyRepair table
      3. Get to know the Loan table
   2. GROUPING SETS
      1. Multiple grouping with UNION ALL
      2. Multiple grouping with UNION ALL – practice
      3. Multiple groupings with GROUPING SETS
      4. Multiple groupings with GROUPING SETS – practice
      5. Using an empty grouping set
      6. Using an empty grouping set – practice
      7. GROUPING SETS with GROUPING_ID
      8. GROUPING SETS with GROUPING()
      9. GROUPING SETS with COALESCE()
      10. GROUPING SETS with ROLLUP and CUBE
      11. GROUPING SETS with ROLLUP and CUBE – practice
   3. Summary
      1. Summary
      2. Exercise 1
      3. Exercise 2
      4. Congratulations

4. 4. Final Quiz

   0/8

   Verify how much you've learned with us in this course.

   List of exercises Buy course
   1. Introduction
      1. Introduction
   2. Quiz
      1. Get to know the CompanyCarTrip table
      2. Question 1
      3. Question 2
      4. Question 3
      5. Question 4
      6. Question 5
   3. The End
      1. Congratulations

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more