>>>>I have a table that includes these three fields: soc_sec_num, activate_code, and ded_code. I need to find only the duplicate records where the soc_sec_num, activate_code, and ded_code are the same.
>>>>
>>>>Can anbody help with the SQL to do this?
>>>>
>>>>Thanks!
>>>>
>>>>Jeff
>>>
>>>Select * From yourtable Group By soc_sec_num, activate_code, ded_code Having Count(*)>1
>>
>>
>>great !!!
>
>It is the most common question someone can meet going to interview for Foxpro position.

That means, I will be failed....

Actually I am very weak in SQL and article which was provided in KB recently has improved it somewhat..