What is Aggregate Functions?

Posted by

To view Verified answers click on the button below.

Aggregate functions perform a calculation on a set of values and return a single value.
Aggregate functions ignore NULL values except COUNT function. HAVING clause is used,
along with GROUP BY, for filtering query using aggregate values.
Following functions are aggregate functions.
AVG, MIN CHECKSUM_AGG, SUM, COUNT, STDEV, COUNT_BIG, STDEVP, GROUPING, VAR,
MAX. VARP