SQLite Group By
GROUP BY 按列分组配合聚合函数，SELECT 中的非聚合列必须出现在 GROUP BY 里。
Key PointsSQLite,GROUP BY,分组
讲解
GROUP BY 按列分组配合聚合函数，SELECT 中的非聚合列必须出现在 GROUP BY 里。
示例
SQL
SELECT country, count(*) AS cnt FROM company GROUP BY country;讲解
GROUP BY 按列分组配合聚合函数，SELECT 中的非聚合列必须出现在 GROUP BY 里。
示例
SQL
SELECT country, count(*) AS cnt FROM company GROUP BY country;