Member Avatar for beginner123

I'm trying to display only rows where the identity column is divisible by 5. Could someone help with this?

  • 2 Contributors
  • 2 Replies
  • 264 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by beginner123
Member Avatar for pty

I'm trying to display only rows where the identity column is divisible by 5. Could someone help with this?

select id from mytable mt where (mt.id % 5) = 0
Member Avatar for beginner123 
select id from mytable mt where (mt.id % 5) = 0

Thanks very much!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.