如果我们想在 select 查询中对非分组字段使用分组函数，则必须使用 group by 子句。一般语法可以如下
语法select group_function1,…, non-group-column1,… from table_name group by column_name;
示例mysql> select count(*), id from student group by id;+----------+------+| count(*) | id |+----------+------+| 1 | 1 || 1 | 2 || 1 | 15 || 1 | 17 || 1 | 20 |+----------+------+5 rows in set (0.00 sec)mysql> select count(*), address from student group by id;+----------+---------+| count(*) | address |+----------+---------+| 1 | delhi || 1 | mumbai || 1 | delhi || 1 | shimla || 1 | jaipur |+----------+---------+5 rows in set (0.00 sec)
group by 子句后的字段可以与 select 查询中给出的非组字段不同。
以上就是我们如何在 mysql select 查询中将组函数与非组字段一起使用？的详细内容。