Revision as of 13:19, 19 March 2009

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