haju__log

[lv.2] NULL 처리하기 본문

programmers_프로그래머스

[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;