SQL query MOD

  • Setharial
  • Born
  • Born
  • User avatar
  • Posts: 4

Post 3+ Months Ago

I'm trying to pull records of a column but only if they have an even number. I know it has something to do with the MOD function or statement, but I'm unable to get it right? The datatype for the column i'm polling from is NUMBER.

THANKS!
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Managedlinks
  • Proficient
  • Proficient
  • Managedlinks
  • Posts: 294

Post 3+ Months Ago

select column from table where MOD(column,2) = 0;

Post Information

  • Total Posts in this topic: 2 posts
  • Users browsing this forum: No registered users and 107 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.