SQLite Having 子句
HAVING 过滤分组后的结果，作用在聚合之后。
Key PointsSQLite,HAVING,分组过滤
讲解
HAVING 过滤分组后的结果，作用在聚合之后。
示例
SQL
SELECT country, count(*) FROM company GROUP BY country HAVING count(*) > 1;讲解
HAVING 过滤分组后的结果，作用在聚合之后。
示例
SQL
SELECT country, count(*) FROM company GROUP BY country HAVING count(*) > 1;