Parent Records With Only One Child Record In SOQL In Salesforce / General Knowledge / By Ntsh SELECT AccountId, count(Id) FROM Contact GROUP BY AccountId HAVING count(Id) = 1