[String, Date/LEVEL3] 조회수가 가장 많은 중고거래 게시판의 첨부파일 조회하기 (MySQL/Oracle)

MySQL

SELECT CONCAT('/home/grep/src/', BOARD_ID, '/', FILE_ID, FILE_NAME, FILE_EXT) AS 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/' || B.BOARD_ID || '/' || B.FILE_ID || B.FILE_NAME || B.FILE_EXT AS FILE_PATH
FROM (SELECT *
        FROM (SELECT *
                FROM USED_GOODS_BOARD
                ORDER BY VIEWS DESC
             )
WHERE ROWNUM  = 1
      ) A, USED_GOODS_FILE B
WHERE A.BOARD_ID = B.BOARD_ID
ORDER BY B.FILE_ID DESC;