[프로그래머스]가장 비싼 상품 구하기 (mysql)

문제

오답

select PRODUCT_ID,PRODUCT_NAME,PRODUCT_CD,CATEGORY,max(PRICE) as price 
from FOOD_PRODUCT

풀이

SELECT * from FOOD_PRODUCT
where price = (select max(price) from FOOD_PRODUCT )