SQLite SUM Function
The SQLite SUM function is used to return the summed value of an expression.
Syntax when you use SUM function with GROUP BY clause:
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:
Example2: Using mathematical formula with SUM function
You can use mathematical formula with SUM function.
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.