Development questions
Write a SOQL query to find duplicate Contacts based on the Email field (SELECT Email, COUNT(Id) FROM Contact GROUP BY Email HAVING COUNT(Id) > 1).
Group by Email and keep groups with more than one row.
soql
SELECT Email, COUNT(Id) cnt FROM Contact
WHERE Email != null
GROUP BY Email
HAVING COUNT(Id) > 1
Each result row is an AggregateResult giving the duplicate email and how many times it appears.
soqlscenarioaggregateduplicates
More Development questions
- What is an Apex Trigger in Salesforce and when should you use it over Flows?
- What is the difference between before triggers and after triggers?
- Explain all Trigger context variables (isInsert, isUpdate, isDelete, isUndelete, isBefore, isAfter, isExecuting, size, operationType).
- What is the difference between Trigger.new and Trigger.old?
- In which trigger events are Trigger.new and Trigger.newMap available?
- In which trigger events are Trigger.old and Trigger.oldMap available?