The HAVING clause search conditions are identical to WHERE search conditions except that WHERE search conditions cannot include aggregates, while HAVING search conditions often do.

• HAVING子句搜索条件基本上等同于WHERE搜索条件,只是WHERE搜索条件不能包括集合函数,而HAVING搜索条件经常包括集合函数。