Difference between revisions of "SUM()"

From Recital Documentation Wiki
Jump to: navigation, search
(SUM())
(Products)
Line 22: Line 22:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Revision as of 16:33, 8 December 2009

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