BookatlasTwo-Day MuleSoft → Salesforce Bootcamp
2 / 18 · Module 5 — Salesforce Data Model + SOQL · filtered: cheatsheet← prev⊞ allnext →

5.31COUNT

Example:

SELECT COUNT()
FROM Account
WHERE Status__c = 'Active'

Salesforce supports aggregation such as COUNT() in SOQL.

Useful for:

validation
reconciliation
monitoring

For example:

source reports: 8,421 active customers
Salesforce reports: 8,419 active accounts

That doesn't prove two records are missing correctly—but it tells you to investigate.