select rows divisible by 5

Expand Post »

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

Similar Threads

MySQL SELECT rows In a Date Range in MySQL
Parsing CSV with php in PHP
Search Code Question in MS Access and FileMaker Pro
table and the index size(individually). in MS SQL
table and the index size(individually). in MS SQL

beginner123

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jul 2006

Permalink

Jul 17th, 2006

Re: select rows divisible by 5

Quote originally posted by beginner123 ...

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

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

pty

Reputation Points: 64

Solved Threads: 39

Posting Pro

Offline

530 posts
since Oct 2005

Permalink

Jul 18th, 2006

Re: select rows divisible by 5

Quote originally posted by pty ...

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!

beginner123

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jul 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Extracting data

Next Thread in MS SQL Forum Timeline: Hi,Need help on sql select statement structure

DaniWeb Message

Cancel Changes

User Name
Password