Explain AVG function in SQL Server.

The AVG function is used to return the average value of a numeric column.

Ex :

Select avg(EmployeesSalary) as AverageSalary from Employees

This Query will display the average value of “EmployeesSalary” column fields, the output will be displayed with the column name ”AverageSalary”.