SQLite SUM Function

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

Syntax:

snippet
SELECT SUM(aggregate_expression)
FROM tables
[WHERE conditions];

Syntax when you use SUM function with GROUP BY clause:

snippet
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:

Sqlite Sum function 1

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

snippet
SELECT SUM(FEES) AS "Total Fees"
FROM STUDENT
WHERE ID <= 5;

Output:

Sqlite Sum function 2

Example2: Using mathematical formula with SUM function

You can use mathematical formula with SUM function.

snippet
SELECT SUM(FEES / 12) AS "Total Monthly Fees"
FROM STUDENT;

Output:

Sqlite Sum function 3

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.

snippet
SELECT ADDRESS, SUM(FEES) AS "Total Salary"
FROM STUDENT
WHERE ID <= 5
GROUP BY ADDRESS;

Output:

Sqlite Sum function 4
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents