sql case end

select b,c,
CASE a  
 WHEN '1' THEN '1001'
 WHEN '2' THEN '1002'
ELSE '1003'
 end
 from test1

用法二:

CASE 
WHEN sex = '1' THEN '1001' 
WHEN sex = '2' THEN '1002' 
ELSE '1003' 
END

结果如果是null，将null变为0
coalesce(filed,0)函数

部分借鉴原作者：http://t.zoukankan.com/tiancai-p-4809814.html