Difference between revisions of "AVG()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) (→AVG()) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Returns an average value in a SELECT statement | Returns an average value in a SELECT statement | ||
Revision as of 17:07, 26 October 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 Database Server, Recital Mirage Server, Recital Terminal Developer
