Even or odd in SQL
select, sql, sql-server, t-sql
Solution
How about
select
id,
~id & 1,
id & 1
from t
Problem
This is table structure ``` id 1 2 3 4 5 6 ``` I need result like this ``` id even odd 1 0 1 2 1 0 3 0 1 4 1 0 5 0 1 6 1 0 ``` I tried ``` select id %2=0 then 1 else 0 end or id%2 <>0 then 1 else 0 odd from table ```