Development questions
What is the difference between WHERE and HAVING clauses in SOQL?
WHERE filters individual rows before grouping and cannot use aggregate functions. HAVING filters groups after GROUP BY and works with aggregate functions.
soql
SELECT AccountId, COUNT(Id) FROM Contact
WHERE Email != null
GROUP BY AccountId
HAVING COUNT(Id) > 5
soqlaggregategroup-by
More Development questions
- What is an Apex Trigger in Salesforce and when should you use it over Flows?
- What is the difference between before triggers and after triggers?
- Explain all Trigger context variables (isInsert, isUpdate, isDelete, isUndelete, isBefore, isAfter, isExecuting, size, operationType).
- What is the difference between Trigger.new and Trigger.old?
- In which trigger events are Trigger.new and Trigger.newMap available?
- In which trigger events are Trigger.old and Trigger.oldMap available?