[Programmers SQL 고득점 Kit] IS NULL [3/3] NULL 처리하기

James Jung·2021년 7월 26일
0
post-thumbnail

문제 link
https://programmers.co.kr/learn/courses/30/lessons/59410

Code link
https://github.com/JamesJung01/programmers_sql_kit/blob/main/04_IS_NULL/IS_NULL-3.sql

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

0개의 댓글