1.

What Is Aggregate Functions?

Answer»

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

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


Discussion

No Comment Found

Related InterviewSolutions