MySQL avg() function

The MySQL avg() function is used to return the average value of an expression.

Syntax:

snippet
SELECT AVG(aggregate_expression)
FROM tables
[WHERE conditions];

Parameter explanation

aggregate_expression: It specifies the column or expression that will be averaged.

table_name: It specifies the tables, from where you want to retrieve records. There must be at least one table listed in the FROM clause.

WHERE conditions: It is optional. It specifies the conditions that must be fulfilled for the records to be selected.

MySQL avg() function example

Consider a table named "employees", having the following data.

mysql average 1

Execute the following query:

snippet
SELECT AVG(working_hours) AS "Avg working hours"
FROM employees
WHERE working_hours > 5;

Output:

mysql average 2
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents