>Hi Sergey!
>
>Are there some difference in performance will have been written thus?
>>select KeyFld from TestDups group by 1 ;
> having count(KeyFld) > 1 ;
> into cursor curDupes
>
>Bye!Erick
I am not sure, even if it works properly, that it is ANSI compliant.
Besides, you are not creating the Count calculated column, therefore you will not know how many duplicates of each you have, which may be important.