https://programmers.co.kr/learn/courses/30/lessons/59036
์ฝ๋ฉํ ์คํธ ์ฐ์ต - ์ํ ๋๋ฌผ ์ฐพ๊ธฐ
ANIMAL_INS ํ ์ด๋ธ์ ๋๋ฌผ ๋ณดํธ์์ ๋ค์ด์จ ๋๋ฌผ์ ์ ๋ณด๋ฅผ ๋ด์ ํ ์ด๋ธ์ ๋๋ค. ANIMAL_INS ํ ์ด๋ธ ๊ตฌ์กฐ๋ ๋ค์๊ณผ ๊ฐ์ผ๋ฉฐ, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE๋ ๊ฐ๊ฐ ๋๋ฌผ์ ์์ด๋
programmers.co.kr
ํ์ด
SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE INTAKE_CONDITION = 'Sick''๐๏ธ Algorithm > โฌ ํ๋ก๊ทธ๋๋จธ์ค' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
| [Programmers] [SQL] ๋๋ฌผ์ ์์ด๋์ ์ด๋ฆ (0) | 2022.03.14 |
|---|---|
| [Programmers] [SQL] ์ด๋ฆฐ ๋๋ฌผ ์ฐพ๊ธฐ (0) | 2022.03.14 |
| [Programmers] [SQL] ์ญ์ ์ ๋ ฌํ๊ธฐ (0) | 2022.03.14 |
| [Programmers] [SQL] ๋ชจ๋ ๋ ์ฝ๋ ์กฐํํ๊ธฐ (0) | 2022.03.14 |
| [Programmers] [2019 ์นด์นด์ค ๊ฐ๋ฐ์ ๊ฒจ์ธ ์ธํด์ญ] [Python] Level1_ํฌ๋ ์ธ ์ธํ๋ฝ๊ธฐ ๊ฒ์ (0) | 2022.03.11 |