Difference between revisions of "SUM()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
|||
Line 26: | Line 26: | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
+ | [[Category:SQL Functions]] |
Revision as of 03:34, 7 December 2012
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