Karen: Makes perfect sense. A null does not equal or duplicate another null. Thanks
Bruce
-------- Original Message --------
Subject: [RBASE-L] - Re: GROUP BY ... HAVING: Epic Fail
From: [email protected]
Date: Sat, July 07, 2012 8:52 am
To: [email protected] (RBASE-L Mailing List)
Bruce: Delete duplicates won't work if you have nulls in any
of the columns. I think if you SET EQNULL ON before the
delete, then it will delete duplicates with nulls
Karen
In a message dated 7/6/2012 7:46:41 PM Central Daylight Time, [email protected] writes:
>Bill:
>
>PROJECTed a temp table 'humpty'. Created an index on serialno.
>
>Command: DELETE DUPLICATES FROM humpty
>
>...either as-is or with a USING collist results in:
>
>'0 row(s) have been deleted from humpty'
>
>There are a truck-load of duplicate rows.
>
>Snake-bit
>
>Bruce
