% MODULO
a % b | ||
---|---|---|
Engine | OK | Alternative |
ingres | No | MOD(a,b) |
mysql | Yes | MOD(a,b) |
oracle | No | MOD(a,b) |
postgres | Yes | MOD(a,b) |
sqlserver | Yes |
% (Modulo)
a % b returns the remainder when a is divided by b
If you use a % 2 you get 0 for even numbers and 1 for odd numbers.
If you use a % 10 you get the last digit of the number a.
27 % 2 -> 1 27 % 10 -> 7