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

sql modulus operation
Ronalds Mazītis picture Ronalds Mazītis · Sep 14, 2013 · Viewed 36.2k times · Source

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.

Answer

Steve Homer picture Steve Homer · Sep 14, 2013 
SELECT * FROM table WHERE MOD (num, 2) = 1 ORDER BY id  ASC;

Will return all of the odd values of num.

Related questions

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

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?

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More