Javatpoint Logo
Javatpoint Logo

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:

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.

Output:

Sqlite Sum function 4
Next Topic#




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA