>Whoops! Mea culpa. I misread it.

No problem. What did you *think* was wrong?

>I still like this way the best as it gives all the duplicates rather than just a list of the contents >of one of the duplicated fields.

It all depends on what you need, right? <g>

Mike

>Alan
>
>>I like this way the best myself, but unfortunately, it is not ansi compliant, and won't work in VFP8 without setting enginebehavior first.
>>
>>Alan
>>
>>>Allen,
>>>
>>>How about
>>>
>>>

>>>select * from lineitems ;
>>>where lineitems_id IN (select lineitems_id from lineitems ;
>>>                       group by 1 ;
>>>                       having count(lineitems_id) > 1) ;
>>>order by lineitems_id ;
>>>into cursor curDupes
>>>

>>>
>>>
>>>>>>>>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