General information
Category:
Coding, syntax & commands
>>>>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..
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only