sum()

Calculates the sum of all expressions that belong to the group. It eliminates expression pairs where either expression in the pair is NULL or not numeric.

Syntax

sum(NUM_EXPR)
NUM_EXPR
Numeric expression