haju__log
[lv.2] NULL 처리하기 본문
반응형
SELECT ANIMAL_TYPE,
CASE WHEN NAME IS NULL THEN "No name"
ELSE NAME
END AS "NAME"
,SEX_UPON_INTAKE
FROM ANIMAL_INS;
반응형
SELECT ANIMAL_TYPE,
CASE WHEN NAME IS NULL THEN "No name"
ELSE NAME
END AS "NAME"
,SEX_UPON_INTAKE
FROM ANIMAL_INS;