SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NULL ORDER BY ANIMAL_ID;
SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NOT NULL ORDER BY ANIMAL_ID;
SELECT ANIMAL_TYPE, IFNULL(NAME, "No name") AS NAME, SEX_UPON_INTAKE FROM ANIMAL_INS ORDER BY ANIMAL_ID;
IFNULL(a,b)
-a๊ฐ null์ด๋ฉด b๋ก ๋์ฒด
'๐ Programming > SQL' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
[MYSQL] Data INSERT, UPDATE, DELETE (0) | 2021.02.25 |
---|---|
[MYSQL] ์ฐ์ ์ ์๊ฑฐํธ๊ฐ ๋ด๊ธด ์ฅ๋ฐ๊ตฌ๋ (0) | 2021.02.16 |
[MYSQL] SELECT groupby FROM Programmers (0) | 2021.01.31 |
[MYSQL] SELECT sum,max,min FROM Programmers (0) | 2020.12.30 |
[MYSQL] SELECT select FROM Programmers (0) | 2020.12.26 |