Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
If I say
SELECT count(id), field_one__c, field_two__c
WHERE field_once__c > 1 AND field_two__c < 6
GROUP BY field_one__c, field_two__c
could I have it only return groups where the size is more than 1? I understand there is a having clause, but I do not believe it works with 'where'
The HAVING clause works perfectly fine for this requirement. Just remember it goes after GROUP BY.
SELECT ... FROM ... WHERE ... GROUP BY ... HAVING count(Id) > 1
