AVG()

From Recital Documentation Wiki
Revision as of 15:59, 26 November 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 Server, Recital