Lesson: 31 | Counting Contacts for Accounts

Notes

Notes

In this Query, we aim to write a SOQL (Salesforce Object Query Language) query that retrieves all Accounts with more than five associated Contacts. The goal is to not only fetch the Accounts but also include the count of their Contacts.

SELECT AccountId, Account.Name, COUNT(Id)
FROM Contact
GROUP BY AccountId, Account.Name
HAVING COUNT(Id) > 5

You need to login to have access to the quizzes.

Mastered by 13 users.

Apex Beginner

A. Apex Fundamentals (23 lessons)

B. Apex Collections (6 lessons)

C. SOQL (32 lessons)

You need to complete all the quizzes before certification.

Go to top

Login to your account

Lesson: 31 | Counting Contacts for Accounts

Notes

Apex Beginner