Ordering
1. The scope of this part of the course
Limiting the output
Eliminating duplicate results
Aggregation
Grouping
HAVING: filtering and ordering groups
Let's practice

Instruction

Welcome to the fourth part of our SQL Basics in MS SQL Server course!

In the previous two parts, you learned how to select data from single and multiple tables. You also know how to filter rows and join columns from different tables.

In this part, you'll learn how to compute statistics, group rows, and filter groups. Such operations are extremely important for preparing reports and always come with handy in big tables.

Are you ready?

Exercise

Click Next exercise to proceed.