+ Start a Discussion

SOQL query to select records with a non-unique field?



I have a custom text field serving as an external, non-unique ID labeled "E_Policy_ID__c." I would like to extract all records for this object where E_Policy_ID__c is NOT unique.


Can anyone give any tips on a SOQL query that I can use in Workbench or Data Loader? I'd like to avoid extracting ALL object records and then using Excel sleuthing to find the non-unique rows.


Thank you!




Suppose the object is account, then you can query like:


SELECT E_Policy_ID__c FROM Account


GROUP BY E_Policy_ID__c


HAVING count(E_Policy_ID__c)>1


Also i would suggest you to install Dupe Catcher app from appexchange which is free of cost and stops duplication.