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);

(1155)

Written by 

I am Sakthivel Madesh, a certified Salesforce Developer & Administrator working on Salesforce Technology since 2011. I am currently working in IBM Austraila as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 12x Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply