AVG()

Purpose

Returns an average value in a SELECT statement

Syntax

AVG(<expN>)

See Also

AGGREGATES, COUNT(), MAX(), MIN(), SELECT, SUM()

Description

Returns the average value of <expN>.

Example

SELECT AVG(sal) Average FROM accounts