프로그래머스 ORACLE 가격이 제일 비싼 식품의 정보 출력하기

<오답>

SELECT PRODUCT_ID, PRODUCT_NAME, PRODUCT_CD, CATEGORY, MAX(PRICE) PRICE
FROM FOOD_PRODUCT
GROUP BY PRODUCT_ID, PRODUCT_NAME, PRODUCT_CD, CATEGORY

 

<정답>

1.ROWNUM 활용

SELECT *
FROM (
    SELECT *
    FROM FOOD_PRODUCT
    ORDER BY PRICE DESC
)
WHERE ROWNUM = 1;

2.서브쿼리 활용

SELECT *
FROM FOOD_PRODUCT
WHERE PRICE = (SELECT MAX(PRICE) FROM FOOD_PRODUCT);