[CONCAT] 조회수가 가장 많은 중고거래 게시판의 첨부파일 조회하기

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

 

SELECT CONCAT("/home/grep/src/", B.BOARD_ID, "/",A.FILE_ID, A.FILE_NAME,A.FILE_EXT) AS FILE_PATH
FROM USED_GOODS_FILE AS A 
LEFT JOIN USED_GOODS_BOARD AS B ON A.BOARD_ID= B.BOARD_ID
WHERE B.VIEWS = (SELECT VIEWS FROM USED_GOODS_BOARD ORDER BY VIEWS DESC LIMIT 1)
ORDER BY A.FILE_ID DESC;