Having Clause
Contents
Having Clause#
Having 子句与 Where 子句作用类似,Having 子句可以让过滤 GroupBy 后的各种数据,Where 子句用于在聚合前过滤记录。
Syntax#
HavingClause
::= 'HAVING' Expression
SQL语句模版#
SELECT select_expr [,select_expr...] FROM ... GROUP BY ... HAVING having_condition
边界说明#
SELECT语句元素 |
状态 |
说明 |
---|---|---|
HAVING Clause |
Online 不支持 |
Having 子句与 Where 子句作用类似,Having 子句可以让过滤 GroupBy 后的各种数据,Where 子句用于在聚合前过滤记录。 |
Example#
1. 分组后按聚合结果过滤#
-- desc: 分组后聚合过滤
SELECT COL1, SUM(COL2), AVG(COL2) FROM t1 group by COL1 HAVING SUM(COL2) > 1000;
2. 两列分组后按聚合结果过滤#
-- desc: 分组后聚合过滤
SELECT COL1, SUM(COL2), AVG(COL2) FROM t1 group by COL1, COL0 HAVING SUM(COL2) > 1000;
3. 分组后按分组列过滤#
-- desc: 分组后聚合过滤
SELECT COL1, SUM(COL2), AVG(COL2) FROM t1 group by COL1 HAVING COL2 > 1000;