sum#
- sum(input)[source]#
Calculates the sum of non-null elements in the input expression.
Example:
SQL#SELECT sum(x) FROM tbl
Input#╭───────╮ │ x │ │ --- │ │ Int64 │ ╞═══════╡ │ 100 │ ├╌╌╌╌╌╌╌┤ │ 200 │ ├╌╌╌╌╌╌╌┤ │ null │ ╰───────╯ (Showing first 3 of 3 rows)
Output#╭───────╮ │ x │ │ --- │ │ Int64 │ ╞═══════╡ │ 300 │ ╰───────╯ (Showing first 1 of 1 rows)