SQL中的case when then else end用法

---------------------------------------------------------------------------------------------------------

--简单Case函数
CASE sex
         WHEN '1' THEN ''
         WHEN '2' THEN ''
ELSE '其他' END
--Case搜索函数
CASE WHEN sex = '1' THEN ''
         WHEN sex = '2' THEN ''
ELSE '其他' END

----------------------------------------------------------------------------------------------------------

SELECT distinct C.TC006 AS 供应商编,
(SELECT case C.TC006 
when '20019' then '柏腾' 
when '20024' then '夏廷' 
when '20023' then '刘友' 
when '20014' then '应朝晖抛' 
else '无此供应' 
end tt) as 供应商名
FROM MOCTA A,MOCTB B,MOCTE E,MOCTC C
WHERE A.TA001=B.TB001 AND A.TA002=B.TB002 AND A.TA001=E.TE011 AND A.TA002=E.TE012 AND E.TE001=C.TC001 AND E.TE002=C.TC002
AND A.TA001 IN (SELECT TE011 FROM MOCTE WHERE TE001='5504' AND TE002 IN (SELECT TC002 FROM MOCTC WHERE TC001='5504' AND TC003 >='20140601' AND TC003<='20140630'AND TC009 = 'N')AND TE008<>'113')
AND A.TA002 IN (SELECT TE012 FROM MOCTE WHERE TE001='5504' AND TE002 IN (SELECT TC002 FROM MOCTC WHERE TC001='5504' AND TC003 >='20140601' AND TC003<='20140630'AND TC009 = 'N')AND TE008<>'113')
AND B.UDF03='Y'
AND E.TE001='5504' AND E.TE002 IN (SELECT TC002 FROM MOCTC WHERE TC001='5504' AND TC003 >='20140601' AND TC003<='20140630'AND TC009 = 'N')AND E.TE008<>'113'

 
---------------------------------------------------------------------------------------------------------- 

📱 扫码关注公众号

扫描二维码关注我们，获取更多精彩内容
实时更新 · 干货满满