SUM()
Anonymous contributor
Anonymous contributor1 total contribution
Anonymous contributor
Published May 5, 2021Updated Jul 26, 2022
Contribute to Docs
The SUM()
aggregate function takes the name of a column as an argument and returns the sum of all the value in that column.
Syntax
SELECT SUM(column_name)FROM table_name;
Example
For instance, suppose there’s a transactions
table with the following values:
date | amount |
---|---|
2023-01-30 | 2.75 |
2023-01-31 | 6.00 |
2023-01-31 | 4.20 |
The given query will return the sum of all values from the amount
column:
SELECT SUM(amount)FROM transactions;
The result would be:
SUM(amount) |
---|
12.95 |
All contributors
- Anonymous contributorAnonymous contributor1 total contribution
- christian.dinh2481 total contributions
- Anonymous contributorAnonymous contributor3077 total contributions
- Anonymous contributor
- christian.dinh
- Anonymous contributor
Looking to contribute?
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.