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!!!
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