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.