MySQL SUM()

MySQL SUM() Function

The SUM() function is used to calculate the total sum of values within a numeric column.

The SUM() function ignores NULL values in the column.

SUM() Syntax

SELECT SUM(column_name)
FROM table_name
WHERE condition;

Demo Database

Below is a selection from the "OrderDetails" table in the Northwind sample database:

SUM() Example

The following SQL returns the sum of the Quantity field in the "OrderDetails" table:

Example

SELECT SUM(Quantity)
FROM OrderDetails;

Note: NULL values are ignored.

Add a WHERE Clause

You can add a WHERE clause to specify conditions.

The following SQL returns the sum of the Quantity field for the product with ProductID = 11, in the "OrderDetails" table:

Example

  SELECT SUM(Quantity)
FROM OrderDetails
WHERE ProductId = 11;