select t.C_OPERATE_TIME MODIFY_TIME,t.c_code EMPLOYEE_CODE,t.c_name EMPLOYEE_NAME,CASE t.c_employee_statusWHEN '在職' THEN1WHEN '實習(xí)生' THEN1ELSE0END BL_FLAG,t.c_labor_date CREATE_TIME,CASE t.c_ctf_typeWHEN '身份證' THEN'01'WHEN '護照' THEN'08'ELSE'99'END USERCARDTYPE,t.c_personal_id USERCARDID,t1.c_name TITLE,t2.c_code ORG_CODE,t3.c_mobile_tel PHONE,t3.c_office_tel TELEPHONE,1 BL_SEND_GAIN,1 BL_DISPATCH_GAIN,'hcmSync' CREATE_USER_CODE,'hcmSync' MODIFY_USER_CODE,0 DEL_FLAG,'雙重身份' EMPLOYEE_TYPE,'ZS_ZY' EMPLOYEE_SOURCEfrom T_BASE_STA_EMP tleft join T_BASE_ORG_POSITION t1on t.c_position_hid = t1.c_oidleft join T_BASE_ORG_ORGUNIT t2on t.c_dept_hid = t2.c_hidleft join t_base_sta_attached t3on t.c_oid = t3.c_oidwhere t.c_operate_time >to_date('2018-07-18 00:00:00', 'yyyy-MM-dd hh24:mi:ss')

　　

轉(zhuǎn)載于:https://www.cnblogs.com/feifeicui/p/9337273.html

總結(jié)

以上是生活随笔為你收集整理的sql的case when用法的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。