SUM
Given a set of numeric values, SUM returns the total of all values in the input set.
Syntax
SUM (expression)
Remarks
• The expression is a numeric expression.
• SUM works only with numeric data types and data types that can be converted to numeric.
• The sum of a table with empty rows or no rows is NULL.
The following table lists the input types that you can use in SUM, and their corresponding INTEGER output types.
Data Type of expression | Output Type |
BIGINT, DOUBLE, INTERVAL_DAY, INTERVAL_YEAR, SMALLINT, TINYINT | BIGINT |
VARCHAR | DECIMAL(41,2) |
FLOAT, REAL | FLOAT |
DECIMAL(p,s), NUMERIC(p,s) | DECIMAL (p+6, s)
For example, the output of SUM(DECIMAL (4, 2) would be SUM(DECIMAL (10, 2) |
NULL | NULL |
Example
SELECT SUM (products.UnitPrice) Total
FROM /shared/examples/ds_inventory/products products