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

문제

MYSQL

내가 작성한 정답

SELECT CONCAT('/home/grep/src/',BOARD_ID,'/',FILE_ID,FILE_NAME,FILE_EXT) FILE_PATH
FROM USED_GOODS_FILE
WHERE BOARD_ID = (SELECT BOARD_ID FROM USED_GOODS_BOARD ORDER BY VIEWS DESC LIMIT 1)
ORDER BY FILE_ID DESC;

ORACLE

내가 작성한 정답

SELECT '/home/grep/src/'||BOARD_ID||'/'||FILE_ID||FILE_NAME||FILE_EXT FILE_PATH
FROM USED_GOODS_FILE
WHERE BOARD_ID IN (SELECT BOARD_ID FROM USED_GOODS_BOARD ORDER BY VIEWS DESC FETCH FIRST 1 ROW ONLY)
ORDER BY FILE_ID DESC;