SUM()

From Recital Documentation Wiki
Revision as of 13:19, 19 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SUM()

Class

SQL Applications


Purpose

Returns a summed value in a SELECT statement


Syntax

SUM(<expN>)


See Also

AGGREGATES, AVG(), COUNT(), MAX(), MIN(), SELECT, SUM()


Description

Returns the sum of values of <expN>.


Example

SELECT SUM(sal) Total FROM accounts;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer