조회수가 가장 많은 중고거래 게시판

LJM·2023년 8월 1일
0

programmers

목록 보기
38/92

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

SELECT CONCAT('/home/grep/src/', USED_GOODS_BOARD.BOARD_ID, '/' , USED_GOODS_FILE.FILE_ID, USED_GOODS_FILE.FILE_NAME ,USED_GOODS_FILE.FILE_EXT) AS FILE_PATH
FROM USED_GOODS_BOARD
INNER JOIN USED_GOODS_FILE
ON USED_GOODS_BOARD.BOARD_ID = USED_GOODS_FILE.BOARD_ID
WHERE USED_GOODS_BOARD.VIEWS = (SELECT MAX(VIEWS) FROM USED_GOODS_BOARD)
ORDER BY USED_GOODS_FILE.FILE_ID DESC
profile
게임개발자 백엔드개발자

0개의 댓글