CASE
WHEN
THEN
END
์์
https://programmers.co.kr/learn/courses/30/lessons/59409
์ฝ๋ฉํ ์คํธ ์ฐ์ต - ์ค์ฑํ ์ฌ๋ถ ํ์ ํ๊ธฐ
ANIMAL_INS ํ ์ด๋ธ์ ๋๋ฌผ ๋ณดํธ์์ ๋ค์ด์จ ๋๋ฌผ์ ์ ๋ณด๋ฅผ ๋ด์ ํ ์ด๋ธ์ ๋๋ค. ANIMAL_INS ํ ์ด๋ธ ๊ตฌ์กฐ๋ ๋ค์๊ณผ ๊ฐ์ผ๋ฉฐ, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE๋ ๊ฐ๊ฐ ๋๋ฌผ์ ์์ด๋
programmers.co.kr
SELECT ANIMAL_ID, NAME,
CASE WHEN
SEX_UPON_INTAKE LIKE 'Neutered%' OR SEX_UPON_INTAKE LIKE 'Spayed%'
THEN 'O' ELSE 'X'
END AS ์ค์ฑํ
FROM ANIMAL_INS
ORDER BY ANIMAL_ID'DB > SQL' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
| SQL - UPPER(), ROWER() (0) | 2022.06.17 |
|---|---|
| SQL - ์ฐ์ฐ์ IN (0) | 2022.06.17 |
| SQL - JOIN (0) | 2022.06.14 |
| SQL - NVL() (0) | 2022.06.14 |
| SQL - HAVING (0) | 2022.06.13 |
CASE
WHEN
THEN
END
์์
https://programmers.co.kr/learn/courses/30/lessons/59409
์ฝ๋ฉํ ์คํธ ์ฐ์ต - ์ค์ฑํ ์ฌ๋ถ ํ์ ํ๊ธฐ
ANIMAL_INS ํ ์ด๋ธ์ ๋๋ฌผ ๋ณดํธ์์ ๋ค์ด์จ ๋๋ฌผ์ ์ ๋ณด๋ฅผ ๋ด์ ํ ์ด๋ธ์ ๋๋ค. ANIMAL_INS ํ ์ด๋ธ ๊ตฌ์กฐ๋ ๋ค์๊ณผ ๊ฐ์ผ๋ฉฐ, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE๋ ๊ฐ๊ฐ ๋๋ฌผ์ ์์ด๋
programmers.co.kr
SELECT ANIMAL_ID, NAME,
CASE WHEN
SEX_UPON_INTAKE LIKE 'Neutered%' OR SEX_UPON_INTAKE LIKE 'Spayed%'
THEN 'O' ELSE 'X'
END AS ์ค์ฑํ
FROM ANIMAL_INS
ORDER BY ANIMAL_ID'DB > SQL' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
| SQL - UPPER(), ROWER() (0) | 2022.06.17 |
|---|---|
| SQL - ์ฐ์ฐ์ IN (0) | 2022.06.17 |
| SQL - JOIN (0) | 2022.06.14 |
| SQL - NVL() (0) | 2022.06.14 |
| SQL - HAVING (0) | 2022.06.13 |
