数据库高级操作case when 数据库高级操作case when 数据库高级操作case when select case when 字段名 = 值 then '男' when 字段名 = 值 then '女' else ‘保密’ end as gender, count(id) as total_cnt form t_user group by gender