Latest revision as of 12:03, 2 September 2012

% (Modulo)

a % b returns the remainder when a is divied 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

In this example you get the final digit year of the games.

SELECT MOD(yr,10),
       yr, city
  FROM gisq.games

SELECT yr % 10,
       yr, city
  FROM games

@@ Line 23: / Line 23: @@
 SELECT MOD(yr,10),
         yr, city
-   FROM games
+   FROM gisq.games
 </source>
 <source lang='sql' class='def'>
@@ Line 36: / Line 36: @@
    <li>[[MOD |MOD function]]</li>
 </ul>
+{{Languages}}