Phoenix Phoenix - 3 months ago 8
SQL Question

Finding even or odd ID values

I was working on a query today which required me to use the following to find all odd number ID values

(ID % 2) <> 0


Can anyone tell me what this is doing? It worked, which is great, but I'd like to know why.

Answer

ID % 2 is checking what the remainder is if you divide ID by 2. If you divide an even number by 2 it will always have a remainder of 0. Any other number (odd) will result in a non-zero value. Which is what is checking for.