코딩연습이 좋아서/SQL이 좋아서

NULL 처리하기

zoaseo 2025. 2. 1. 11:46

SELECT ANIMAL_TYPE,	
IFNULL(NAME, 'No name'),
SEX_UPON_INTAKE
FROM ANIMAL_INS 
ORDER BY ANIMAL_ID;