AVG()

From Recital Documentation Wiki
Revision as of 17:07, 26 October 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search

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;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer