SUM Function
Next: SQL GROUP BY
The SUM function is used to calculate the total for a column. The syntax is,
SELECT SUM("column_name")
FROM "table_name"
For example, if we want to get the sum of all sales from the following table,
Table Store_Information
| store_name | Sales | Date |
| Los Angeles | $1500 | Jan-05-1999 |
| San Diego | $250 | Jan-07-1999 |
| Los Angeles | $300 | Jan-08-1999 |
| Boston | $700 | Jan-08-1999 |
we would type in
SELECT SUM(Sales) FROM Store_Information
Result:
| SUM(Sales) |
$2750 represents the sum of all Sales entries: $1500 + $250 + $300 + $700.