Home SALESFORCEAPEX How do Count the number of child records using SOQL

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

You may also like

Leave a Comment