Where (mod(column,50)) = 1 Is the same as 1 = (mod(column,50)) when I ran this against a table I got 1 51 101 151 201
Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Atrix Wolfe Sent: Thursday, November 21, 2002 12:46 PM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: modulus that is interesting, why is it 1 = instead of = 1? Will it run faster that way? ----- Original Message ----- From: "Troy Sosamon" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 12:39 PM Subject: RE: Witango-Talk: modulus > You should be able to get this to work, but you need to think backwards. > Try something like this: > > select ..... where 1 = (mod(colname,50)) > > Remember you want to look at the mod of the col value and find the results > that equal 1. > > Troy Sosamon > > -------- Original Message -------------- > > hello, i have a table, and for paging reasons, i want to get every entry > where: > > count modulus 50=1 > and > count modulus 50=0 > > this would make it so i could make a drop down list that had ranges like: > > 1..50 > 51..100 > 101..150 > > etc. > > problem is i cant find how to do modulus in SQL. Is there a way? If not is > there another way to do this without a for loop? > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
