I know this has been answered but since no sum was given - for other peoples
interest you could also use the MOD function
even:
select * from query1 where rowid mod 2 = 0
odd
select * from query1 where rowid mod 2 = 1
I believe this approach to be better because it can be used to get every Xth
row
eg
Xth row:
select * from query1 where rowid mod X = 0
Cheers
Martin
==================================
Martin Roundill
GIS Manager
Waitakere City Council
Private Bag 93109
Henderson
Waitakere City
New Zealand
-----Original Message-----
From: Erick Posner [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 5 March 2000 12:06
To: Dyan Catamaran; SA de CV
Cc: [EMAIL PROTECTED]
Subject: Re: MI odd/even query
Or you could do this:
even:
select * from query1 where rowid\2 = rowid/2
odd:
select * from query1 where rowid\2 != rowid/2
!= means "does not equal"
also can use <> as "does not equal"
----- Original Message -----
From: Geograf�a y Electr�nica, SA de CV <[EMAIL PROTECTED]>
To: Dyan Catamaran <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, March 03, 2000 5:04 PM
Subject: Re: MI odd/even query
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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
