Example
Return the sum of the “Quantity” field in the “OrderDetails” table:
SELECT SUM(Quantity) AS TotalItemsOrdered FROM OrderDetails;
Definition and Usage
The SUM() function calculates the sum of a set of values.
Note: NULL values are ignored. Continue reading MySQL SUM Function