SUM()

From Lianjapedia
Revision as of 10:46, 7 December 2012 by Helen.george (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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
Retrieved from "https://www.lianja.com/doc/index.php?title=SUM()&oldid=4878"