Aggregate Functions

COUNT, SUM, AVG, MIN, MAX and how they treat NULL.

2 notes

Notes

The five aggregate functions that collapse many rows into one value, the three forms of COUNT, and what each one does with NULL.

SQL

Aggregating an expression rather than a column: weighted totals, conditional counts and the difference between counting rows and counting facts.