You need to sign in to do that
Don't have an account?
tengel
SOQL query to select records with a non-unique field?
Hello,
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!
Hello,
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.