MySQL SUM Function

Introduction to MySQL SUM Function

This MySQL tutorial explains how to use the MySQL SUM function with syntax and examples. The MySQL SUM function returns the summed value of an expression.

SUM() Syntax

SELECT SUM(column_name)
FROM table_name
WHERE condition;

To understand SUM function, consider an “OrderDetails” table, which is having the following records:

SELECT * FROM OrderDetails;

The following MySQL statement finds the sum of the “Quantity” fields in the “OrderDetails” table:

SELECT SUM(Quantity) AS TotalQuantity
FROM OrderDetails;