select Id,NAME,JOB,ORG_ID
CASE
WHEN MODIFY_TYPE ==1 THEN '入职'
WHEN MODIFY_TYPE == 2 THEN '异动'
WHEN MODIFY_TYPE ==3 THEN '离职'
END MODIFY_TYPE
from AD_EMP
提示语法错误~ 请指出哪里错了?~谢谢!
CASE
WHEN MODIFY_TYPE ==1 THEN '入职'
WHEN MODIFY_TYPE == 2 THEN '异动'
WHEN MODIFY_TYPE ==3 THEN '离职'
END MODIFY_TYPE
from AD_EMP
提示语法错误~ 请指出哪里错了?~谢谢!
CASE
WHEN MODIFY_TYPE =1 THEN '入职'
WHEN MODIFY_TYPE = 2 THEN '异动'
WHEN MODIFY_TYPE =3 THEN '离职'
END) MODIFY_TYPE
from AD_EMP
select Id,NAME,JOB,ORG_ID,
CASE
WHEN MODIFY_TYPE =1 THEN '入职'
WHEN MODIFY_TYPE = 2 THEN '异动'
WHEN MODIFY_TYPE =3 THEN '离职'
END MODIFY_TYPE
from AD_EMP