[lv.2] NULL 처리하기

haju 2024. 8. 5. 11:55

SELECT ANIMAL_TYPE,
CASE WHEN NAME IS NULL THEN "No name"
    ELSE NAME
END AS "NAME"
,SEX_UPON_INTAKE
FROM ANIMAL_INS;