MySQL数据库-数据的分组操作（group by）命令演示

分组 group by

group by

# 对原始数据筛选 分组 在聚合函数的基础上分组，否则没有意义

• 按照性别分组, 查询所有的性别
  select gender from students group by gender;
  失败select * from students group by gender;
  失败 select name from students group by gender;

• 计算每种性别中的人数
  select gender,count(*) from students group by gender;

• 计算男性的人数
  select gender,count(*) from students where gender=1 group by gender;

group_concat(…)

分组后显示group_concat()内的内容 ()内写什么，就连接显示什么

• select gender, group_concat(name) from students where gender=1 group by gender;
  select gender, group_concat(name, age, id) from students where gender=1 group by gender;
  select gender, group_concat(name, “_”, age, " ", id) from students where gender=1 group by ge