SELECT CASE

SELECT CASE <조건 기준>
            WHEN <CASE 조건> THEN <입력값>
            WHEN <CASE 조건> THEN ( CASE<조건 기준2>
                                                  WHEN <CASE조건2> THEN (입력값) END )
         END AS <필드명>

 

SELECT CASE carrid
         WHEN 'AA' THEN ( CASE connid 
                             WHEN '0017' THEN 'CASE TEST!'
                             ELSE 'other AA' END )
         ELSE 'NOT'
       END AS test
  FROM sflight
  INTO TABLE @DATA(lt_test).

 

테스트 결과값