How do Count the number of child records using SOQL?

Its possible to collect the child records count from parent object using following SOQL:
SELECT Id, Name, (SELECT id FROM Contacts) FROM Account limit 10

Map<Id, Integer> ContactCountMap = new Map<Id, Integer>();
List<Account> lstAccount= [SELECT Id, Name, (SELECT id FROM Contacts) FROM Account limit 10];
for (Account A : lstAccount) {
ContactCountMap.put(A.Id, A.Contacts.size());
}
system.debug(‘ContactCountMap:::::’ContactCountMap);

Written by 

2x Salesforce MVP | Platform Champion | 18x Salesforce Certified | MuleSoft Certified | 8x Trailhead Ranger | TechForce Services | Sydney | Australia

Leave a Reply

Your email address will not be published. Required fields are marked *

*