avg() - MySQL Aggregate Function

In MySQL, the avg() function is used to calculate the average value of a set of values. It is an aggregate function, which means that it operates on a set of rows and returns a single value as the result. In this tutorial, we'll discuss how to use the avg() function in MySQL.

Syntax

The syntax for the avg() function is as follows:

SELECT AVG(column_name) FROM table_name;

Here, column_name is the name of the column that you want to calculate the average for, and table_name is the name of the table that contains that column.

Example

Let's say we have a table called "employees" that contains a column called "salary". We can use the avg() function to calculate the average salary of all employees in the table:

SELECT AVG(salary) FROM employees;

This will return the average salary as a single value.

Output

When we run the example code above, the output will be a single value representing the average salary of all employees in the table.

Explanation

In the example above, we used the avg() function to calculate the average salary of all employees in the table. The function takes a column name as its argument and returns a single value representing the average of all values in that column.

Use

The avg() function is useful when you want to calculate the average value of a set of values in MySQL. This can be useful for a variety of applications, such as calculating the average price of products in a store or the average score for a group of students.

Important Points

• The avg() function only operates on numeric data types.
• If a column contains NULL values, the avg() function will return NULL unless you use the IFNULL function to convert NULL values to 0 or another value.
• The avg() function ignores non-numeric values in a column when calculating the average.

Summary

In this tutorial, we discussed how to use the avg() function in MySQL to calculate the average value of a set of values. We covered the syntax, example, output, explanation, use, and important points of the avg() function in MySQL. With this knowledge, you can use the avg() function to efficiently calculate averages of sets of values within your MySQL databases.