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

I need only even or odd items, so I find modulus operation and this doesn't works

SELECT * FROM table ORDER BY id WHERE MOD (num, 2) = 1 ASC;

Please help me, I'm noob in sql, as I haven't done much in it.

## Answers

SELECT * FROM table WHERE MOD (num, 2) = 1 ORDER BY id ASC;

Will return all of the odd values of num.

for even

where ([num]% 2) = 0

for odd

where ([num]% 2) <>0

SELECT * FROM table WHERE MOD(num, 2) = 1 ORDER BY id ASC;

After fetching the final resultSet for the sql server based on where condition then only we can apply any ordering either ASC and DESC.

For even, query:

SELECT * FROM table_name WHERE MOD(NUM, 2) = 0 ORDER BY ID ASC;

For odd, query:

SELECT * FROM table_name WHERE MOD(NUM, 2) != 0 ORDER BY ID ASC;