Difference between revisions of "AVG()"

From Lianjapedia
Jump to: navigation, search
 
m (1 revision: SQL)
(No difference)

Revision as of 04:17, 25 October 2011

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