CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Mark Redman
Mark Redman

Reputation: 24535

SQL Server SQL Select: How do I select rows where sum of a column is within a specified multiple?

I have a process that needs to select rows from a Table (queued items) each row has a quantity column and I need to select rows where the quantities add to a specific multiple. The mulitple is the order of between around 4, 8, 10 (but could in theory be any multiple. (odd or even)

Any suggestions on how to select rows where the sum of a field is of a specified multiple?

Upvotes: 0

Views: 245

Answers (1)

Kevin Ross
Kevin Ross

Reputation: 7215

My first thought would be to use some kind of MOD function which I believe in SQL server is the % sign. So the criteria would be something like this

WHERE MyField % 4 = 0 OR MyField % 8 = 0

It might not be that fast so another way might be to make a temp table containing say 100 values of the X times table (where X is the multiple you are looking for) and join on that

Upvotes: 1

Related Questions