msyql查询各部门性别人数,如果某个部门没有男生或女生则用0代替
根据部门或者班级查询男女各多少人,可以直接使用:
select org_code as orgCode, sex, count(*) as totalCount from blade_student where is_deleted=0 GROUP BY org_code, sex order by org_code
所得结果如下:
但是,比如编码为03的,并不存在女生,人数就查不出来。
解决方案如下:
select org_code, sum(case when sex=1 then 1 else 0 end) as boy,
sum(case when sex=2 then 1 else 0 end) as girl from blade_student where is_deleted=0 GROUP BY org_code
order by org_code
直接查各性别的人数