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
1 comments
13:21 Nov 28, 2019
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