easy, selecting row numbers 2 through 8: ################### Select * from YourTable where RowID > 1 and RowID < 10 ###################
ash -----Original Message----- From: Windeler, David [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 4 February 2003 6:19 AM To: 'MapInfo-L (E-mail) Subject: MI-L select by row number To whom it may concern: I am wondering if it is possible to select items from a table based on their row numbers? I am aware that you can retrieve the row-ID value of a selected object but I wish to write an SQL statement that selects a series of items based on a row number range. Is this possible? David Windeler Hons. BSc. Geo, GIS Apps. Specialist GIS Technician / Applications Specialist City Of Vaughan Engineering Department 2141 Major Mackenzie Drive Vaughan, Ontario L6A 1T1 Tel. (905) 832-8525 Ext. 8747 Fax (905) 832-6145 E-mail [EMAIL PROTECTED] http://www.city.vaughan.on.ca --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5341
