(
CASE
WHEN T2.BLESSNUM IS NULL
THEN 0
ELSE T2.BLESSNUM
ENCODE( T2.BLESSNUM, NULL,0,T2.BLESSNUM) AS BLESSNUM
ENCODE(t.status,'C','审批通过','P','审批中','N','未提交','D','审批未通过')
as status
CASE
WHEN T2.BLESSNUM IS NULL
THEN 0
ELSE T2.BLESSNUM
END) AS BLESSNUM
或者
ENCODE( T2.BLESSNUM, NULL,0,T2.BLESSNUM) AS BLESSNUM
ENCODE(t.status,'C','审批通过','P','审批中','N','未提交','D','审批未通过')
as status
两种用法在没有涉及到的结果通通为null,判断一个结果值是否为空用is null或者is not null 而不是=null 或者==null