case sex when 1 then 'man' when 2 then 'women' end; case when sex=1 then 'man' when sex=2 then 'women' end sex; 上两个语句是相同的结果 当判断为空输出的时候 case when sex is null then ‘未选择’ else then '选择了' end sex;