SQL - AVG() Function

The AVG() is an aggregate function that is used to find out an average of the list of values of columns or an expression.

The AVG() function is used with the numeric columns only.

Syntax:

SELECT AVG(column_name) FROM table_name WHERE condition;

For the demo purpose, we will use the following Employee table in all examples here.

The following query calculates the average salary of all the employees.

SELECT AVG(Salary) AS AVERAGE FROM Employee;

You can also calculate the average salary of each department using the following command:

SELECT DeptId, AVG(Salary) AS AVERAGE FROM Employees GROUP BY DeptId;