AVG()

From Recital Documentation Wiki
Revision as of 13:16, 19 March 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

AVG()

Class

SQL Applications


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

Retrieved from "https://www.recitalsoftware.com/wiki/index.php?title=AVG()&oldid=3440"