Aggregation on zero rows behaves as indicated by the following table.
| Aggregate Function | Result When There Are Zero Rows |
|---|---|
| COUNT(expression) WHERE … | 0 |
| all other forms of aggregate_operator (expression) WHERE … | Null |
| aggregate_operator (expression) … GROUP BY … aggregate_operator (expression) … HAVING … |
No Record Found |