case when的几种用法

用法一（case 字段 when）：

select
case c_sex when 1 then '男'
else '女'
end as '性别',
count(*) as '人数' from user_inofr
group by '性别'

 

用法二（case when 字段）：

select
case when c_sex=1 then '男'
else '女'
end as '性别',
count(*) as '人数' from user_inofr
group by '性别'

 

用法三（部分处理，其他保留原样）：

select
case when c_quantity is null then '0'
else c_quantity
end as '用量',
count(*) from material_detail
group by '用量'

用法四（between）：

select
case when c_month between 1 and 3 then '一'
when c_month between 4 and 6 then '二'
when c_month between 7 and 9 then '三'
else '四'
end as '季度',sum(c_salesum) '销量' FROM spiderdata_car_salesum
group by 季度
order by 季度