Progress
SQL-92
Guide and Reference


SUM Function

Returns the sum of the values in a group. The keyword DISTINCT specifies that the duplicate values are to be eliminated before computing the sum.

SYNTAX

SUM ( { [ALL] expression } | { DISTINCT column_ref } ) 

EXAMPLE

This example illustrates the SUM function:

SELECT SUM (amount)
     FROM orders
     WHERE order_date = SYSDATE ; 

NOTES


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095