Group by, distinct, top and count clauses - T-SQL Step by Step Course - Lesson 7 | SQL courses

Duration: 16:12 min

Summary: In this video, we will continue the select statement discussion. After discussing the ‘use’ statement in the previous video, now we move to the group by clause. We know that when our managers need to get a report, they would like to see it grouped by a certain category. The data will make more sense when specific groups are being investigated. So, we will experiment with the group by clause today, and also look at ‘distinct’ and ‘count’. ‘count’ will help us determine how many rows we have in a specific table, and distinct, we will help us remove redundant data. Finally, we will look at the ‘top’ keyword to retrieve data from the top and the bottom part of the table.

Technologies and Resources: T-SQL, SQL Server 2012 Express, AdventureWorks 2012, Database, Schema.