HAVING 子句

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;