SQLite SUM Function

by Online Tutorials Library July 14, 2022

SQLite SUM Function

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

Syntax:

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:

Sqlite Sum function 1

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

Output:

Sqlite Sum function 2

Example2: Using mathematical formula with SUM function

You can use mathematical formula with SUM function.

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.

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

Output:

Sqlite Sum function 4

Next Topic#

SQLite SUM Function

SQLite SUM Function

Assumptions of Cronbach’s Alpha in SPSS

Escaping and Non-Escaping Closures in Swift

You may also like