group by的使用说明
<div id="cnblogs_post_body">SQL HAVING 出现的原因
在 SQL 中增加 HAVING 子句原因是，WHERE 关键字无法与合计函数一起使用。
SQL HAVING 语法
<div class="cnblogs_code">SELECT column_name, aggregate_function(column_name)FROM table_nameWHERE column_name operator valueGROUP BY column_nameHAVING aggregate_function(column_name) operator value
页:
[1]