SQLite - Arithmetic Operators

Advertisements


Assume variable a holds 10 and variable b holds 20, then SQLite arithmetic operators will be used as follows:

OperatorDescriptionExample
+Addition - Adds values on either side of the operator a + b will give 30
-Subtraction - Subtracts right hand operand from left hand operand a - b will give -10
*Multiplication - Multiplies values on either side of the operator a * b will give 200
/Division - Divides left hand operand by right hand operand b / a will give 2
%Modulus - Divides left hand operand by right hand operand and returns remainder b % a will give 0

Example

Here are simple examples showing usage of SQLite Arithmetic Operators:

sqlite> .mode line
sqlite> select 10 + 20;
10 + 20 = 30


sqlite> select 10 - 20;
10 - 20 = -10


sqlite> select 10 * 20;
10 * 20 = 200


sqlite> select 10 / 5;
10 / 5 = 2


sqlite> select 12 %  5;
12 %  5 = 2


Advertisements
Advertisements