82
MySQL AVG() Function
The avg() is a Math function of MySQL. This function is used to get the average value from the given expression.
Syntax
Parameter
aggregate_expression: It is the column name for getting average
table_name: It is the table for getting records.
where condition: It is optional. It is used to get conditional records.
Returns
This function returns the average value from the given expression.
Table:
Example 1
Output:
Example 2
Output:
Example 3
Output:
Next TopicMySQL Math