AVG()

From Lianjapedia
Revision as of 13:14, 22 December 2009 by Yvonnemilne (Talk)

(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.lianja.com/doc/index.php?title=AVG()&oldid=1415"