SQL can perform arithmetic operations like addition, subtraction, division or modulus.
Modulus is the remainder of a division between two numbers. It is
represented by the symbol %.
Modulus is sometimes also referred to as modulo.
Modulo is written as:
4 % 2
For example when dividing numbers say
10 and 3,
results in a remainder of
1
While dividing numbers
7 and 4,
results in a remainder of
3