๐Ÿ’ SQL/Select

[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] SQL ๊ณ ๋“์  Kit : ์กฐ๊ฑด์— ๋ถ€ํ•ฉํ•˜๋Š” ์ค‘๊ณ ๊ฑฐ๋ž˜ ๋Œ“๊ธ€ ์กฐํšŒํ•˜๊ธฐ

์„ ๋‹ฌ 2023. 4. 5. 22:30
๋ฐ˜์‘ํ˜•

https://school.programmers.co.kr/learn/courses/30/lessons/164673

 

ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค

์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”.

programmers.co.kr

 

-- ์ฝ”๋“œ๋ฅผ ์ž…๋ ฅํ•˜์„ธ์š”
SELECT board.TITLE, board.BOARD_ID, reply.REPLY_ID, reply.WRITER_ID, reply.CONTENTS, 
date_format(reply.CREATED_DATE, "%Y-%m-%d") as CREATED_DATE
from USED_GOODS_REPLY as reply 
join USED_GOODS_BOARD as board
on reply.BOARD_ID = board.BOARD_ID
where date_format(board.CREATED_DATE, "%y-%m") = "22-10"
order by reply.CREATED_DATE asc, board.TITLE asc

 

์ด๊ฒŒ ์–ด๋–ป๊ฒŒ level 1์ด์•ผ ๋ง๋„์•ˆ๋ผ

๋ฐ˜์‘ํ˜•