반응형
SQL을 슬슬 준비하기 시작해야겠다!
|
1
2
3
4
5
6
7
8
9
10
|
-- 코드를 입력하세요
SELECT TITLE, BOARD.BOARD_ID, REPLY_ID, REPLY.WRITER_ID, REPLY.CONTENTS, DATE_FORMAT(REPLY.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATE
FROM USED_GOODS_REPLY AS REPLY
LEFT JOIN USED_GOODS_BOARD AS BOARD
ON BOARD.BOARD_ID=REPLY.BOARD_ID
WHERE DATE_FORMAT(BOARD.CREATED_DATE, '%Y-%m-%d') LIKE '2022-10%'
ORDER BY REPLY.CREATED_DATE, BOARD.TITLE
|
cs |
반응형
