[IS NULL] - NULL 처리

[문제 설명]

[No name으로 null값 처리]

-- Mysql
-- SQL CASE 예
SELECT OrderId, Quantity,
CASE
    WHEN Quantity > 30 THEN 'The quantity is greater than 30'
    WHEN Quantity = 30 THEN 'The quantity is 30'
    ELSE 'The quantity is under 30'
END AS QuantityText
FROM OrderDetails

-- MySQL

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

 

---

[case문 참고]

https://www.w3schools.com/sql/sql_case.asp

SQL CASE Statement