AVG « Aggregate Functions « SQL Server / T-SQL






1.AVG() function returns the average for a range of numeric values, for all non-null values.
2.AVG: get the average value for a column
3.AVG: Null values are ignored
4.AVG returns the average of the values in expression