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 |