coalesce
๐ก COALESCEํจ์๋ ์ธ์๋ก ์ฃผ์ด์ง ์ปฌ๋ผ๋ค ์ค์์ NULL์ด ์๋ ์ฒซ ๋ฒ์งธ ๊ฐ์ ๋ฐํid | name | age |
---|---|---|
1 | James | NULL |
2 | Ann | 25 |
3 | Alice | NULL |
SELECT id,
name,
coalesce(age, 'Unknown') age
FROM customers;
id | name | age |
---|---|---|
1 | James | Unknown |
2 | Ann | 25 |
3 | Alice | Unknown |