Aggregation on zero rows behaves as indicated by the following table.
| This form of aggregate function … | Returns this 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 |