Latest revision as of 12:09, 2 September 2012

MOD

MOD(a,b) returns the remainder when a is divied by b

If you use MOD(a, 2) you get 0 for even numbers and 1 for odd numbers.

If you use MOD(a, 10) you get the last digit of the number a.

 MOD(27,2) ->  1
 MOD(27,10) ->  7

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

SELECT yr % 10, yr, city
FROM games

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

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

@@ Line 4: / Line 4: @@
 <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr>
 <tr><td align='left'>ingres</td><td>Yes</td><td></td></tr>
-<tr><td align='left'>mysql</td><td>Yes</td><td>[[a % b]]</td></tr>
+<tr><td align='left'>mysql</td><td>Yes</td><td>[[%25_MODULO |a % b]]</td></tr>
 <tr><td align='left'>oracle</td><td>Yes</td><td></td></tr>
-<tr><td align='left'>postgres</td><td>Yes</td><td>[[a % b]]</td></tr>
+<tr><td align='left'>postgres</td><td>Yes</td><td>[[%25_MODULO |a % b]]</td></tr>
-<tr><td align='left'>sqlserver</td><td>No</td><td>[[a % b]]</td></tr>
+<tr><td align='left'>sqlserver</td><td>No</td><td>[[%25_MODULO |a % b]]</td></tr>
 </table>
 <h1>MOD</h1>
@@ Line 19: / Line 19: @@
 <div class='ht'>
-With a <code>GROUP BY region</code> statement each region shows up just once. The SUM column gives the total for each region.
+In this example you get the final digit year of the games.
 <source lang='sql' class='def e-sqlserver'>SELECT yr % 10, yr, city
 FROM games
+</source>
+<source lang='sql' class='def e-oracle'>SELECT MOD(yr,10),
+       yr, city
+  FROM gisq.games
 </source>
 <source lang='sql' class='def'>SELECT MOD(yr,10),
@@ Line 32: / Line 36: @@
    <li>[[CEIL |CEIL function]]</li>
 </ul>
+{{Languages}}