title: How to select odd or even items from a row in SQL?
body: <p>I need only even or odd items, so I find modulus operation and this doesn't works</p>
  
  <pre><code>SELECT  * FROM table ORDER BY id WHERE MOD (num, 2) = 1 ASC;
  </code></pre>
  
  <p>Please help me, I'm noob in sql, as I haven't done much in it.</p>