>>>>>>>>>>>>>>>>>>>>>
>>Try this:
>>
>>SELECT * FROM TableName ;
>> WHERE Name IN (SELECT Name FROM TableName GROUP BY Name HAVING COUNT(*) > ) ;
>> INTO TABLE Duplicates
>>>>>>>>>>>>>>>>>>>>>
>
>Minor typo correction:
>
>
>SELECT * FROM TableName ;
> WHERE Name IN ;
> (SELECT Name FROM TableName GROUP BY Name HAVING COUNT(*) > 1) ;
> INTO TABLE Duplicates
>

We forgot one thing to make it easier to see the duplicates together:


SELECT * FROM TableName ;
WHERE Name IN ;
(SELECT Name FROM TableName GROUP BY Name HAVING COUNT(*) > 1) ;
ORDER BY Name
INTO TABLE Duplicates