更新时间：2026-05-15 GMT+08:00
GROUP BY
完整的分析语句语法如下：
1 2 3 4 | SELECT [DISTINCT] (* | expression) [AS alias] [, ...] [GROUP BY expression [, ...] [HAVING predicates]] [ORDER BY expression [ASC | DESC] [, ...]] [LIMIT size OFFSET offset] |
其中，GROUP BY表示按值分组。本章节内容将介绍GROUP BY语法参数说明及示例。
按字段的值分组
1 | *|SELECT age GROUP BY age |
| age |
|---|
| 28 |
| 32 |
| 36 |
按字段别名分组
1 | *|SELECT account_number AS num GROUP BY num |
| num |
|---|
| 1 |
| 16 |
| 13 |
| 18 |
按多个字段分组
示例1：按多个字段分组，查看不同年龄人数分布。
1 | *|SELECT account_number AS num, age GROUP BY num, age |
| num | age |
|---|---|
| 1 | 32 |
| 16 | 36 |
| 13 | 28 |
| 18 | 32 |
示例2：查看主机hcss_ecs_3924的region分布，按多个字段分组。
hostName = ‘hcss_ecs_3924’|SELECT hostName AS name, region GROUP BY name, region
| name | region |
|---|---|
| hcss_ecs_3924 | cn-north-7 |
使用SQL函数
函数相关内容请参见函数。
1 | *|SELECT LENGTH(lastname) AS len, COUNT(*) AS count GROUP BY LENGTH(lastname) |
| len | count |
|---|---|
| 4 | 2 |
| 5 | 2 |
父主题： 分析语句
