Introduction

Aggregate Functions are used to return a single value, which is calculated from multiple values in a column. Aggregate functions are build in SQL Server functions which are applied to set of records and we get summarized data.

Aggregate Functions

The following are the set of built in Aggregate functions in SQL Server,

• AVG()
• CHECKSUM()
• CHECKSUM_AGG()
• COUNT()
• COUNT_BIG()
• MAX()
• MIN()
• SUM()
• STDEV()
• STDEVP()
• VAR()
• VARP()

#sql