Using Aggregate Functions Aggregate functions in SQL Server 2016 are used to summarize data in multiple rows. Explore various types of aggregate functions such as SUM MIN MAX AVG and COUNT.