you are at Encyclopedia of SQL >> SUM
SUM(`column_name`)
Returns sum of values of specified numeric column.Syntax
SELECT SUM(`column_name`)
FROM `table_name`
Example
Display sum of age of people in table
| name | surname | age |
|---|---|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT SUM(`age`)
FROM `people`
result
| SUM(`age`) |
|---|
| 23 |
