HAVING 子句在 SQL 中增加 HAVING 子句原因是，WHERE 关键字无法与聚合函数一起使用。 HAVING 子句可以让我们筛选分组后的各组数据。 SQL HAVING 语法SQL HAVING 语法SELECT column1, aggregate_function(column2) FROM table_name GROUP BY column1 HAVING condition

Java学习体系