AVG() in MySQL — How It Works

What the MySQL AVG() function does, with an example.

Published October 20, 2026

AVG() returns the average value of a numeric column across matching rows.

Key points

  • Part of standard SQL functions available in MySQL for working with query results

Example

SELECT AVG(price) FROM products;
More SQL articles