At 02:20 P.M. 03/03/2000 -0800, you wrote:
>Hi Users
>
>Is there a way to select a numeric field let's say, the ID populated by
rowid and select either ODD or EVEN ID'S?
>
>I hope it is simple.
>
>Thanks
>
>Dyan C. Catamaran
>Phero Tech Inc.
>--------------------------
>604-940-9944
>604-940-9433
>

even:
select * from query1 where rowid\2 = rowid/2
odd:
select * from query1 where (rowid+1)\2 = (rowid+1)/2

---------------------------------
     Ing. Juan Pufleau Correa
Geografía y Electrónica, SA de CV
      Aguascalientes, Mexico
---------------------------------
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

Reply via email to