์ผ | ์ | ํ | ์ | ๋ชฉ | ๊ธ | ํ |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |
- Servlet
- counter
- Lambda
- ํ
- ํ๋ก๊ทธ๋๋จธ์ค
- ํด์
- jquery
- ์คํ๋ง
- Deque
- ์ฝ๋ฉํ ์คํธ
- JSP
- R
- ๋ฐฑ์ค c++
- ๋ฐฑ์ค
- ์ฝ๋์
- ์ํด๋ฆฌ ์ฑ๋ฆฐ์ง
- ๋ ์์ ํฉ
- ๊ฐ๋ฆ
- MySQL
- ๋ฐฐ์ด
- ํ์ด์ฌ
- 1๋จ๊ณ
- ์๋ฐ
- JavaScript
- Set
- ํฌ ํฌ์ธํฐ
- hash
- ์ฅ๊ณ
- ์คํ
- 2๋จ๊ณ
- Today
- Total
๋ชฉ๋กMySQL (3)
Development
๋ฌธ์ ์ฝ๋ฉํ ์คํธ ์ฐ์ต - ์ค์ฑํ ์ฌ๋ถ ํ์ ํ๊ธฐ | ํ๋ก๊ทธ๋๋จธ์ค ์ค์ฟจ (programmers.co.kr) ํ๋ก๊ทธ๋๋จธ์ค ์ฝ๋ ์ค์ฌ์ ๊ฐ๋ฐ์ ์ฑ์ฉ. ์คํ ๊ธฐ๋ฐ์ ํฌ์ง์ ๋งค์นญ. ํ๋ก๊ทธ๋๋จธ์ค์ ๊ฐ๋ฐ์ ๋ง์ถคํ ํ๋กํ์ ๋ฑ๋กํ๊ณ , ๋์ ๊ธฐ์ ๊ถํฉ์ด ์ ๋ง๋ ๊ธฐ์ ๋ค์ ๋งค์นญ ๋ฐ์ผ์ธ์. 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 FROM ANIMAL_INS case when ์กฐ๊ฑด์ ์ฌ์ฉํด์ฃผ์ด์ผํ๋ค. case when์ ์ฌ์ฉํ๊ณ like๋ฅผ ์ฌ์ฉํด์ ์ค์ฑํ ์ฌ๋ถ๋ฅผ ๋ณด์ฌ์ค๋ค. case when ์ฌ์ฉ๋ฒ CASE WHEN..
์ต๋๊ฐ ๊ตฌํ๊ธฐ select DATETIME as '์๊ฐ' from ANIMAL_INS order by DATETIME desc limit 1 ์ต์๊ฐ ๊ตฌํ๊ธฐ select min(DATETIME) as '์๊ฐ' from ANIMAL_INS ๋๋ฌผ ์ ๊ตฌํ๊ธฐ select count(*) from ANIMAL_INS ์ค๋ณต ์ ๊ฑฐํ๊ธฐ select count(distinct name) from ANIMAL_INS where name is not null
๋ชจ๋ ๋ ์ฝ๋ ์กฐํํ๊ธฐ select * from ANIMAL_INS order by ANIMAL_ID; ์ญ์ ์ ๋ ฌํ๊ธฐ select NAME,DATETIME from ANIMAL_INS order by ANIMAL_ID desc; ์ํ ๋๋ฌผ ์ฐพ๊ธฐ select ANIMAL_ID,NAME from ANIMAL_INS where INTAKE_CONDITION = "Sick" order by ANIMAL_ID ; ์ด๋ฆฐ ๋๋ฌผ ์ฐพ๊ธฐ select ANIMAL_ID,NAME from ANIMAL_INS where INTAKE_CONDITION != "Aged" order by ANIMAL_ID; ๋๋ฌผ์ ์์ด๋์ ์ด๋ฆ select ANIMAL_ID,NAME from ANIMAL_INS order by ANIMAL_ID; ์ฌ..