Blog

Blog » 2025 » July » 22 » SOQL to find dupliucates
03:05
SOQL to find dupliucates

SELECT Case__c, System_Type__c, COUNT(Id) 
FROM Message__c
WHERE System_Type__c = 'reminder'
GROUP BY Case__c, System_Type__c
HAVING COUNT(Id) > 4