MySQL Function Reference

SUM

Returns the sum of values in a column. You can use DISTINCT to sum only unique values.

MySQL 8.1

SUM([DISTINCT] expr)

expr

A numeric expression whose values are summed

Examples

MySQL 8.1

SELECT SUM(amount)
FROM Payments;

MySQL 8.1

SELECT good,
	SUM(unit_price)
FROM Payments
GROUP BY good;