PRODUCT
Description
PRODUCT calculates the product over an INT or FLOAT column.
The data type of the result is the same as the input column data type. So the product of an INT column will be of type INT.
Syntax
PRODUCT ( table.column )
NULL handling
NULL values are ignored, so they do not influence the result. If all the values of a group are NULL or an overflow occurs during calculation, the result for this group is also NULL.
Example
[1] Product of small integers. | ||||||||||||
| ||||||||||||
|
[2] Product of big integers with overflow. | ||||||||||||
| ||||||||||||
|