aggregate function

A function that turns many input rows into one value, such as COUNT, SUM, AVG, MIN or MAX.

In more detail

Without GROUP BY the whole input is one group and the query returns one row. With GROUP BY the aggregate runs separately inside each group. Most aggregates skip NULL values, and every other selected column must be grouped or aggregated.

Related terms

Taught in

References