MS SQL

select rows divisible by 5

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Jul 2006

Posts: 2

Reputation: beginner123 is an unknown quantity at this point

Solved Threads: 0

beginner123 beginner123 is offline

Offline

Newbie Poster

select rows divisible by 5

Jul 17th, 2006

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

•

Join Date: Oct 2005

Posts: 523

Reputation: pty is on a distinguished road

Solved Threads: 37

pty

Offline

Posting Pro

Re: select rows divisible by 5

Jul 17th, 2006

•

Originally Posted by beginner123

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

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT id FROM mytable mt WHERE (mt.id % 5) = 0
select id from mytable mt where (mt.id % 5) = 0

•

Join Date: Jul 2006

Posts: 2

Reputation: beginner123 is an unknown quantity at this point

Solved Threads: 0

beginner123 beginner123 is offline

Offline

Newbie Poster

Re: select rows divisible by 5

Jul 18th, 2006

•

Originally Posted by pty

Help with Code Tags

MS SQL Syntax (Toggle Plain Text)
SELECT id FROM mytable mt WHERE (mt.id % 5) = 0
select id from mytable mt where (mt.id % 5) = 0

Thanks very much!