SQL - Contact duplication

Hello,

Dear community, 

I've one question : 

Can you tell me the SQL request in order to list the duplicated contacts, and the duplicated account. 

I've tried with the generate db structure and asked the several tables but there is nothing which is done. 

 

Can you help me ? 

 

Thanks in advance, 

Best regards 

Like 0

Like

1 comments

Hello Rocher,

This query is based on which field you are using to determine if the contact is duplicate or not. Here is an example of contact duplicates search result via SQL-query by contact name:

select Name, count (Name) Amount from Contact
group by Name
having count (Name) > 1

Best regards,

Oscar

Show all comments