Aggregate Functions : Introduction « Aggregate Functions « MySQL Tutorial






Aggregate functions perform a mathematical operation on a column.

MySQL implements the following aggregate functions:

  1. COUNT(),
  2. COUNT(DISTINCT),
  3. MAX(),
  4. MIN(),
  5. AVG(),
  6. SUM(), and
  7. STD().
16.1.Introduction
16.1.1.Aggregate Functions
16.1.2.Use two aggregate functions in a select statement
16.1.3.Use aggregate function with group by clause