SUM Function

The SQLite SUM function is used to return the summed value of an expression.

Syntax:

SELECT SUM(aggregate_expression)  

FROM tables  

[WHERE conditions];  

Syntax when you use SUM function with GROUP BY clause:

SELECT expression1, expression2, ... expression_n  

SUM(aggregate_expression)  

FROM tables  

[WHERE conditions]  

GROUP BY expression1, expression2, ... expression_n; 

Example1:

We have a table named “STUDENT”, having the following data:

Retrieve total fees of the students where ID is less than or equal to 5:

SELECT SUM(FEES) AS "Total Fees"  

FROM STUDENT  

WHERE ID <= 5;  

Output:

Example2: Using mathematical formula with SUM function

You can use mathematical formula with SUM function.

SELECT SUM(FEES / 12) AS "Total Monthly Fees"  

FROM STUDENT;  

Output:

Example2: Using GROUP BY clause with SUM function:

Retrieve addresses from the table “STUDENT”, find the sum of their corresponding fees and group by the result by address.

SELECT ADDRESS, SUM(FEES) AS "Total Salary"  

FROM STUDENT  

WHERE ID <= 5  

GROUP BY ADDRESS;  

Output: