SQL SUM Function

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:

$2750 represents the sum of all Sales entries: $1500 + $250 + $300 + $700.