# SQL Sum | Sum Function in SQL - sql - sql tutorial - learn sql

• The SUM function is used to calculate the total for an expression.
• The SQL SUM function is used to return the sum of an expression in a SELECT statement.
• SQL SUM function is used to find out the sum of a field in various records.

## Syntax

• The syntax for the SUM function is,
• <expression> can be a column name or an arithmetic operation. An arithmetic operation can include more than one column, such as ("column1" - "column2").
• It is also possible to have one or more columns in addition to the SUM function in the SELECT statement. In those cases, these columns need to be part of the GROUP BY clause as well:

## Examples

• We use the following table for our examples.

## Table Store_Information

Store_Name Sales Txn_Date
Los Angeles 1500 Jan-05-1999
San Diego 250 Jan-07-1999
San Francisco 300 Jan-08-1999
Boston 700 Jan-08-1999

## Example 1: SUM function on a column

• To get the sum of all sales from Store_Information, we type in,

## Result:

SUM(Sales)
2750
• 2750 represents the sum of all Sales entries: 1500 + 250 + 300 + 700.

## Example 2: SUM function on an arithmetic operation

• Assume that sales tax is 10% of the sales amount, we use the following SQL statement to get the total sales tax amount:

## Result:

SUM(Sales*0.1)
275
• SQL will first calculate "Sales*0.1" and then apply the SUM function to the result.

## Example 3: SUM function with a GROUP BY clause

• To get the sum of sales for each store, we type in,

## Result:

Store_Name SUM(Sales)
Los Angeles 1500
San Diego 250
Boston 700