Question
Why should a row-level date filter usually be placed in WHERE rather than HAVING?
Select an option. Your answer will be checked instantly.
Correct Answer: D. WHERE reduces input rows before aggregation and expresses the intended logic
Explanation:
Filtering early reduces the data that must be joined and aggregated.
It also distinguishes row predicates from conditions on aggregate groups.
Leave a Reply