AVG()

From Recital Documentation Wiki
Revision as of 17:14, 22 December 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 Server, Recital

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