Difference between revisions of "AVG()"

From Recital Documentation Wiki
Jump to: navigation, search
(AVG())
(Products)
Line 22: Line 22:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Revision as of 15:59, 26 November 2009

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