SUM

version 11

SUM ([ALL |DISTINCT] arithmetic_expression)

The SUM function returns the sum of the arithmetic_expression. The optional ALL and DISTINCT keywords are used to respectively retain or eliminate any duplicate values.

This example returns the sum of the expected sales less the sum of the actual sales, as well as the minimum and maximum value of the actual sales multiplied by 100 and divided by the expected sales for the SALES_PERSONS table:

   SELECT MIN ( ( SALES * 100 ) / QUOTA ), 
      MAX ( ( SALES * 100 ) / QUOTA ), 
      SUM ( QUOTA ) - SUM ( SALES )
   FROM SALES_PERSONS

AVG, COUNT.