Javatpoint Logo
Javatpoint Logo

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:

Sqlite Sum function 1

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


Sqlite Sum function 2

Example2: Using mathematical formula with SUM function

You can use mathematical formula with SUM function.


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.


Sqlite Sum function 4
Next Topic#

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA