[SQL문제풀기] 가장 비싼 상품 구하기

문제

내가 작성한 정답 1 - MYSQL

SELECT PRICE MAX_PRICE
FROM PRODUCT
ORDER BY PRICE DESC
LIMIT 1;

SELECT PRICE MAX_PRICE
FROM PRODUCT
WHERE PRICE = (SELECT MAX(PRICE) FROM PRODUCT);

내가 작성한 정답 - ORACLE

SELECT PRICE MAX_PRICE
FROM (SELECT PRICE FROM PRODUCT ORDER BY PRICE DESC)
WHERE ROWNUM = 1;

SELECT PRICE MAX_PRICE
FROM PRODUCT
WHERE PRICE = (SELECT MAX(PRICE) FROM PRODUCT);