MYSQL HAVING 字句实现二次筛选

HAVING 字句只有配合GROUP BY使用 才有意义

例子

SELECT sex, GROUP_CONCAT(name) AS users,

COUNT(*) AS total

FROM user

WHERE id > 0

GROUP BY sex 

HAVING COUNT(*)>2 AND MAX(age)>18;