SUM()

From Lianjapedia
Revision as of 04:17, 25 October 2011 by Yvonne.milne (Talk | contribs)

Jump to: navigation, search

Purpose

Returns a summed value in a SELECT statement


Syntax

SUM(<expN>)


See Also

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


Description

Returns the sum of values of <expN>.


Example

SELECT SUM(sal) Total FROM accounts


Products

Recital, Recital Server