식품분류별 가장 비싼 식품의 정보 조회하기 - Oracle

SELECT F.CATEGORY, F.PRICE AS MAX_PRICE, F.PRODUCT_NAME
FROM FOOD_PRODUCT F JOIN (
    SELECT CATEGORY, MAX(PRICE) AS PRICE
    FROM FOOD_PRODUCT
    GROUP BY CATEGORY
    HAVING CATEGORY IN ('과자','국','김치','식용유')
) M
ON F.CATEGORY=M.CATEGORY AND F.PRICE=M.PRICE
ORDER BY F.PRICE DESC;

 

즐겨찾기 문제랑 비슷한 문제 ⭐