统计报表中,为了实现一条mysql语句查询出男女的人数,sql语句如下:
#年末年龄统计表
select
COUNT(case when info.sex = 'm' then sex end ) as maleCount,
COUNT(case when info.sex = 'f' then sex end ) as femaleCount,
COUNT(case when info.sex IN('m','f') then sex end) as allCount
from retire_infor as info
where info.`status`=6;