CASE WHEN的用法

CASE WHEN的用法

SELECT
       MMLH.ENABLE_FLAG,
       MMLH.FREEZE_FLAG,
       (CASE WHEN mmwb. WORKCELL_CODE IS NOT NULL AND mmwb. WORKCELL_NAME IS NOT  NULL
       THEN mmwb. WORKCELL_CODE || '/' || mmwb. WORKCELL_NAME
       WHEN mmwb. WORKCELL_CODE IS NOT NULL AND mmwb. WORKCELL_NAME IS NULL
       THEN mmwb. WORKCELL_CODE
       WHEN mmwb. WORKCELL_CODE IS NULL AND mmwb. WORKCELL_NAME IS NOT NULL
       THEN mmwb. WORKCELL_NAME
       end) workCellAndName
FROM