Selecting rows where remainder (modulo) is 1 after division by 2?

Viewed 113649

There is a column in options that hold an integer. I want to select the row only if that value % 2 = 1.

I know this can be done in 2 queries but is it possible to do it in 1?

4 Answers
Related