MySQL AVG() FunctionThe avg() is a Math function of MySQL. This function is used to get the average value from the given expression. SyntaxParameteraggregate_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. ReturnsThis function returns the average value from the given expression.
Table:Example 1Output: Example 2Output: Example 3Output:
Next TopicMySQL Math
|