# Difference between revisions of "MOD"

From SQLZOO

Line 20: | Line 20: | ||

<div class='qu'> | <div class='qu'> | ||

With a <code>GROUP BY region</code> statement each region shows up just once. The SUM column gives the total for each region. | With a <code>GROUP BY region</code> statement each region shows up just once. The SUM column gives the total for each region. | ||

− | <source lang='sql' class='def e-sqlserver'> | + | <source lang='sql' class='def e-sqlserver'>SELECT yr % 10, |

− | SELECT yr % 10, | + | |

yr, city | yr, city | ||

FROM games | FROM games |

## Revision as of 09:11, 13 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