Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
prerequisite for this rule is that the aggregation function must satisfy . That is, the calculation results of the empty set and the null set by aggregation function must be the same. Note: In MySQL and AnalyticDB for MySQL (ADB) syntax, count does not meet this requirement. ADB is a cloud native