SQL Server: basic functions (part 5) - Aggregation

Tweet

Aggregate functions are used in SQL Server queries to perform operation on a group of values and returns one single value as result. Aggregate functions are used with the SELECT statement, with the GROUP BY and the HAVING clauses.
There are different aggregate functions, however the most important are:

• Count
• Sum
• Avg
• Min
• Max

And those are the functions we are going to see here.