说明
在 SQL 中WHERE 关键字无法与聚合函数一起使用。
HAVING 可以让我们筛选分组后的各组数据。
语法
SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggregate_function(column_name) operator value;
实例
select fid,SUM(fqty) From T_SAL_ORDERENTRY where FSEQ<100 group by fid Having sum(FOLDQTY)>100