DB2 データ有無をフラグに変換

DB2 データ有無をフラグに変換

DB2 | Database |

SELECT A.CNT,
  CASE
   WHEN A.CNT > 0 THEN 1
   ELSE 0 END
FROM (
 SELECT COUNT(FIELD01) CNT
   FROM TEST_TABLE
  WHERE FILED01 = '0000'
) A