How do I select alternate rows (odd or even) from a MapInfo Professional table?


How do I select all even or odd numbered rows in a table?


Navigate to Query>Select, select the table to query from.
In the 'that Satisfy' box type in the following syntax.

rowid mod 2 = 0

This will select all even records.

To select the odd records, simply use the Query>Invert Selection tool.

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Remove Highlighting Remove Highlighting

Edit this article

User Opinions (13 votes)

100% thumbs up 0% thumbs down

How would you rate this article?

Thank you for rating this article.

Related Articles

No related articles were found.


No attachments were found.

Last Updated on: 17th of September, 2009