Arithmetic Functions
Sum
Calculates the sum of numeric values, if there are no rows a NULL value is returned. if a value is non numeric such as a string or null, those values are ignored.
SQL Usage
SELECT sum(column1) FROM ...
Sum0
Calculates the sum of numeric values, if there are no rows a 0 value is returned. if a value is non numeric such as a string or null, those values are ignored.
SQL Usage
SELECT sum0(column1) FROM ...
Min
Returns the minimum value in the result. If there are no rows a NULL value is returned. MIN ignores any null input values.
SQL Usage
SELECT min(column1) FROM ...
Max
Returns the maximum value in the result. If there are no rows a NULL value is returned. MAX ignores any null input values.
SQL Usage
SELECT max(column1) FROM ...