SUM
Returns the sum of all values in a group.
Analyze Syntax
func.sum(get_column(table, 'amount'))
Analyze Examples
func.sum(get_column(table, 'amount'))
SQL Syntax
SUM(<amount>)
SQL Examples
SELECT department, SUM(salary) FROM employees GROUP BY department;
┌────────────┬─────────────┐
│ department │ sum(salary) │
├────────────┼─────────────┤
│ Sales │ 195000 │
│ IT │ 246000 │
│ HR │ 210000 │
└────────────┴─────────────┘