Aggregate functions is used to perform a calculation on a set of values and return a single value. All aggregate functions are deterministicmeans always return the same result any time they are called with a specific set of input values.

Aggregate functions can be used as an expressions only in select list of a SELECT statement, in COMPUTE or COMPUTE BY clause or in HAVING clause.

Below are the aggregate functions available in sql server.