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!
  • 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 131 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.