Using Aggregate Functions to Group Data

Duration:  15 Minutes 15 Seconds (12.9 MB)

Calculating an average or determining the sum of multiple records can be achieved by using the Aggregate functions provided with SQL Server 2005. This SQL Tutorial will show you how to use the most common aggregate functions in SQL Server 2005 and explain to you when they can be used. You will also learn how to write and execture a GROUP BY Query utilizing aggregate functions.

• Overview of SQL Server 2005 Aggregate Functions


• Learn how to use COUNT, SUM, AVG and more


• Learn how to create a GROUP BY query with several examples

Other SQL Tutorials that you might be interested in:

Duration:  9 Minutes 08 Seconds (7.22 MB)

Duration:  11 Minutes 31 Seconds (9.81 MB)