Skip to main content

COUNT, SUM, AVG, MIN & MAX

Learn COUNT, SUM, AVG, MIN & MAX (Aggregate Functions, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction Aggregate functions collapse many rows into one value: COUNT (how many), SUM (total), AVG (mean), MIN and MAX (extremes). Without GROUP BY the whole table becomes one group.

More lessons in Aggregate Functions