AVG()

From Lianjapedia
Revision as of 03:33, 7 December 2012 by Admin (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
Retrieved from "https://www.lianja.com/doc/index.php?title=AVG()&oldid=4414"