Aggregate
Performing a calculation across many rows to produce a single summary value.
Definition
Performing a calculation across many rows to produce a single summary value. Common aggregations include counting rows, summing values, computing averages, and finding minimums or maximums.
Example
SELECT AVG(score) FROM tests WHERE subject = 'Math' — this aggregates all math test scores into a single average.
See it in context Learn how Aggregate fits into the bigger picture of how software actually works.
Read the Guide →