Selecting Even or Odd Records from a Table - MapInfo_Pro - 2023

Every record in a table has a sequential record number or a RowID. Suppose you want to select every other record from your table. The easiest way is to check the table through RowID.

To select records that have an odd record number:

1. On the TABLE tab, click SQL Select. This is also available from the MAP and SPATIAL tabs.
2. Fill in the SQL Select dialog box:
   • Select Columns: *
   • from Tables: SOILS
   • where Condition: ROWID Mod 2 = 0
   • into Table Named: Selection

   RowID is a function, not a column name in the Soils table.

To select records that have an even record number, on the TABLE tab, click SQL Select.

1. Fill in the SQL Select dialog box: Click OK.
   • Select Columns: *
   • from Tables: SOILS
   • where Condition: ROWID Mod 2 > 0
   • into Table Named: Selection

   RowID is a function, not a column name in the Soils table.