SUM returns the aggregate sum of values in a data set..
SUM( [ DISTINCT | ALL ] expression)
- DISTINCT \| ALL: Specifying the DISTINCT keyword excludes duplicate values from the calculation.
- Specifying ALL explicitly includes all values, including duplicates.
- ALL is the default behavior and is not required. </ul>
- expression: The name of an expression on which to average values. expression must resolve to a value that can be averaged. </ul> ## Returns ## The same data type as the source data. ## Additional Information ## * Multiple aggregate functions can be combined in the same query, so long as they comply with the following: * Only one DISTINCT keyword can be used per query. This means that if you are submitting both an [AVG function](/avg_aggregate_function.html) and [SUM function](/sum_aggregate_function.html) in the same query, only one can include the DISTINCT function, even though DISTINCT is supported with each function if submitted individually. ## Examples ## ```sql SELECT SUM(salesTotal) FROM MYSQL.inventory.orders; SELECT SUM(sumCalc) FROM (VALUES (1), (2), (3)) AS myTable (sumCalc); -- Returns 6 SELECT SUM(DISTINCT sumCalc) FROM (VALUES (2), (2), (3)) AS myTable (sumCalc); -- Returns 5 ```