>
>>>Hi,
>>>>Can someone help me with the SQL to find all duplicates in a field?
>>>>Thanks,
>>>>Allen
>>>select KeyFld, count(*) as CntDups from TestDups group by 1 ;
>>> having CntDups > 1 ;
>>> into cursor curDupes
>>>
>>
>>Sorry but I did get it...
>>Keyfld for me is lineitems_id
>>TestDups table is lineitems
>>What's CntDups... a variable?
>>
>>Allen>
>
>CntDups becomes a calculated field in your query result (cursor).
>Basically you are saying to group by "lineitems_id" and count how many show up. Then disregard the ones that show up only once and show only 2 or more instances ("having CntDups > 1").
>
>
>select lineitems_id, count(*) as CntDups ;
>from lineitems ;
>group by 1 ;
>having CntDups > 1 ;
>into cursor curDupes
>
>
>Clearer?
Thank you. It's clearer and works but I needed another thing...
What you gave me shows the duplicate record and the times it's duplicated, but I was trying to get the duplicate records, record by record. So that each record is listed.
Thanks,
Allen