SQL语句----CASE WHEN 的用法简介

SQL文:

     SELECT 

        (CASE WP01.AJM_KIN_KBN WHEN 2 THEN '紧急出荷'

            ELSE CASE WP01.TODOKE_KBN WHEN 1 THEN '病院'

                                                                            WHEN 2 THEN '卸'

                                                                            WHEN 3 THEN WP01.TOKU_NM

                                                                            WHEN 4 THEN '病院'

 

            END

        END)    AS AJM_KIN_KBN

    FROM

        WP01_S_HAITOTAL WP01

//THEN的结果类型必须一致

 

相关式样书:

AJM緊急区分＝１：通常、０：対象外、届先区分：１病院、４：個人→「病院」、
AJM緊急区分＝１：通常、０：対象外、届先区分：２卸→「卸」、
AJM緊急区分＝１：通常、０：対象外、届先区分：３転送→得意先名、
AJM緊急区分＝２：緊急→「緊急出荷」を出力する

AJM緊急区分:WP01.AJM_KIN_KBN

届先区分:WP01.TODOKE_KBN

得意先名:WP01.TOKU_NM