Difference between revisions of "MOD"
From SQLZOO
| Line 4: | Line 4: | ||
<tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr> | <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'>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'>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> | </table> | ||
<h1>MOD</h1> | <h1>MOD</h1> | ||
Revision as of 15:09, 16 July 2012
| MOD(a,b) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | Yes | |
| mysql | Yes | a % b |
| oracle | Yes | |
| postgres | Yes | a % b |
| sqlserver | No | a % b |
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
With a GROUP BY region statement each region shows up just once. The SUM column gives the total for each region.
SELECT yr % 10, yr, city FROM games
SELECT MOD(yr,10), yr, city FROM games
See also
