Difference between revisions of "SUM()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 15: Line 15:
  
 
==See Also==
 
==See Also==
[[SQL Aggregate Functions|AGGREGATES]], [[AVG()]], [[COUNT()]], [[MAX()]], [[MIN()]], [[SQL SELECT|SELECT]], [[SUM()]]
+
[[SQL Aggregate Functions|AGGREGATES]], [[AVG()]], [[COUNT()]], [[MAX()]], [[MIN()]], [[SQL SELECT|SELECT]]
  
  

Revision as of 13:20, 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


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