用法一(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 季度