Cacher is the code snippet organizer for pro developers

-- How to select odd or even items from a row in SQL?

-- четные
SELECT * FROM narod_1c a WHERE a.street like 'Интернациональная' and (house % 2) = 0;
-- нечетные
SELECT * FROM narod_1c a WHERE a.street like 'Интернациональная' and (house % 2) <> 0;

-- http://stackoverflow.com/questions/18805062/how-to-select-odd-or-even-items-from-a-row-in-sql