Revision as of 13:15, 19 March 2009

AVG()

Class

SQL Applications

Purpose

Returns an average value in a SELECT statement

Syntax

AVG(<expN>)

See Also

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

Description

Returns the average value of <expN>.

Example

SELECT AVG(sal) Average FROM accounts;

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer