# Difference between revisions of "% MODULO"

From SQLZOO

Line 36: | Line 36: | ||

<li>[[MOD |MOD function]]</li> | <li>[[MOD |MOD function]]</li> | ||

</ul> | </ul> | ||

+ | |||

+ | {{Languages}} |

## Latest revision as of 12:03, 2 September 2012

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 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