프로그래머스 SQL 풀이 오답노트(2)

SUM, MAX, MIN: 가격이 제일 비싼 식품의 정보 출력하기

Oracle

SELECT PRODUCT_ID, PRODUCT_NAME, PRODUCT_CD, CATEGORY, PRICE
FROM FOOD_PRODUCT
WHERE PRICE = (SELECT MAX(PRICE) FROM FOOD_PRODUCT)

MS SQL Server

SELECT TOP 1 WITH TIES PRODUCT_ID, PRODUCT_NAME, PRODUCT_CD, CATEGORY, PRICE
FROM FOOD_PRODUCT
ORDER BY PRICE DESC;