17,078
社区成员
发帖
与我相关
我的任务
分享
case when subjcode like '6601%' or subjcode like '6602%' or subjcode like '6603%' then subjcode else 'N/A' end
-- 你的语句:
case when subjcode like '6601%' or subjcode like '6602%' or subjcode like '6603%' then subjcode else 'N/A' end
-- 要用decode的话,也只能借助substr()函数,这样写:
decode( substr(subjcode,1,4),'6601',subjcode,'6602',subjcode,'6603', subjcode, 'N/A')
decode()只能用于某一确定值,不能用于范围域值!
-- 如:
(case when col_name=1 then 'OK' when col_name=2 then 'Faild' else 'Un Now' end)
-- 可以替换为:
decode(col_name,1,'OK',2,'Faild','Un Now')