Avg

Description

Computes the average value of an aggregation of values.

Syntax

Avg ( n )

Arguments

n is a numeric expression.

Example

Returns the average and standard deviation of each continent's female population.

select Continent, Avg(Pop_Fem) as Average, StdDev(Pop_Fem) as StandardDeviation FROM countries GROUP BY Continent

Remarks

Avg is an aggregation function which can only be used in an aggregating Select statement. Null values are ignored. If there are only null values supplied in the aggregation, then a null value is returned.