I'm trying to display only rows where the identity column is divisible by 5. Could someone help with this?
beginner123
0
Newbie Poster
Recommended Answers
Jump to PostI'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
All 2 Replies
pty
882
Posting Pro
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
beginner123
0
Newbie Poster
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.