Below is an example of a SQL query which you can use in a scenario where you want to display a list of duplicate records which are stored in a particular table.<\/p>\n
Below is the query that has been used to do the needful on the Leads entity (where Client wanted to have the list of Duplicate Lead records on the basis of Person First name, Last name, Address, City and State).<\/p>\n
SELECT COUNT(*) AS Amount,
Lead_PersonFirstName, Lead_PersonLastName,
Lead_CompanyAddress1,Lead_CompanyAddress2,Lead_CompanyCity,
Lead_CompanyState
INTO ##Temp
FROM Lead
where lead_deleted is null
GROUP BY
Lead_PersonFirstName, Lead_PersonLastName,
Lead_CompanyAddress1,Lead_CompanyAddress2,Lead_CompanyCity,
Lead_CompanyState
HAVING Count(*) > 0 <\/strong><\/p>\n