create or replace view v_ca_variation_crworktask as
select TC.DSGC_CR_UUID, case TC.CR_STATUS
when '1' then TDW.CURRENT_TACHE
when '2' then '关闭'
when '3' then '取消'
end as spare1
from IMS.DSGC_CR TC
left join IMS.IMSWF_DAILYWRK TDW on TC.DSGC_CR_UUID = TDW.BUSS_UUID
ORDER BY TC.DSGC_CR_UUID DESC
中“end as spare1”里面的as是什么意思?
spare1是IMS.IMSWF_DAILYWRK里的一个字段。
select TC.DSGC_CR_UUID, case TC.CR_STATUS
when '1' then TDW.CURRENT_TACHE
when '2' then '关闭'
when '3' then '取消'
end as spare1
from IMS.DSGC_CR TC
left join IMS.IMSWF_DAILYWRK TDW on TC.DSGC_CR_UUID = TDW.BUSS_UUID
ORDER BY TC.DSGC_CR_UUID DESC
中“end as spare1”里面的as是什么意思?
spare1是IMS.IMSWF_DAILYWRK里的一个字段。
when '1' then TDW.CURRENT_TACHE
when '2' then '关闭'
when '3' then '取消'
end
as spare1
end是对case而言的标准格式:case when then endas spare1是给这个值的一个名
相当于 select f1 as 字段1 from tab
-----------
12/04/2007SQL>
-----------
12/04/2007