Skip to content

Instantly share code, notes, and snippets.

@sudhakar6
Last active February 12, 2022 13:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sudhakar6/099192b540cb30d3db2db8eab088721c to your computer and use it in GitHub Desktop.
Save sudhakar6/099192b540cb30d3db2db8eab088721c to your computer and use it in GitHub Desktop.
SOQL Queries
Query duplicate record based on a field:
Field: Account.Email__c
SELECT Email__c, COUNT(Id) FROM Account GROUP BY Email__c HAVING COUNT(Id) > 1 ORDER BY Count(ID) DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment