SOQL to get Account ids where Contact count is greater than 2

Sample Query:

SELECT Account.Id FROM Contact GROUP BY Account.Id HAVING COUNT(Account.Id) > 2

This query is used to get Account ids where Contact count is greater than 2 for the accounts.

Cheers!!!

No comments:

Post a Comment