类似于ORACLE decode 的用法

SQL Server 2008中的写法：
select t.PROJECTNAME, t.BUILDCONTENTSCALE,  CASE t.PROJECTLEVEL      WHEN '0' THEN '国家重点'      WHEN '1' THEN '省重点'      WHEN '2' THEN '市重点'      WHEN '3' THEN '区/县重点'      END AS PROJECTLEVEL, t.TOTALINVESTMENT, t.PROGRESSCONTENT, t.BUILDCOMPANY,  t.CONTACTWAY, t.DUTYDEPT, t.REMARK from t_iipms_applayprojects t  where t.projecttype = '1'   and t.isvoided = '0';
Oracle 10g中的写法：
select t.PROJECTNAME,       t.BUILDCONTENTSCALE,       decode(t.PROJECTLEVEL,              '0',              '国家重点',              '1',              '省重点',              '2',              '市重点',              '3',              '区/县重点') as PROJECTLEVEL,       t.TOTALINVESTMENT,       t.PROGRESSCONTENT,       t.BUILDCOMPANY,       t.CONTACTWAY,       t.DUTYDEPT,       t.REMARK  from t_iipms_applayprojects t where t.projecttype = '1'   and t.isvoided = '0';

细节对比看效果很明显：SQL Server 2008中
CASE t.PROJECTLEVEL      WHEN '0' THEN '国家重点'      WHEN '1' THEN '省重点'      WHEN '2' THEN '市重点'      WHEN '3' THEN '区/县重点'      END AS PROJECTLEVELOracle 10g中decode(t.PROJECTLEVEL,              '0',              '国家重点',              '1',              '省重点',              '2',              '市重点',              '3',              '区/县重点') as PROJECTLEVEL
---------------------
作者：长安散人
来源：CSDN
原文：https://blog.csdn.net/hu_shengyang/article/details/10533865
版权声明：本文为博主原创文章，转载请附上博文链接！

转载于:https://www.cnblogs.com/qiu18359243869/p/10872766.html