✔️ 처음에 작성한 코드
SELECT PRODUCT_ID, PRODUCT_NAME, PRODUCT_CD, CATEGORY, PRICE
from FOOD_PRODUCT
where price = max(PRICE)
SELECT PRODUCT_ID, PRODUCT_NAME, PRODUCT_CD, CATEGORY, PRICE
from FOOD_PRODUCT
where price = (select max(PRICE) from FOOD_PRODUCT)
SELECT *
FROM employees
WHERE salary = (SELECT MAX(salary)
FROM employees
WHERE department_id=30);
-> 부서 id가 30인 부서에서, 최대 급여를 받은 직원의 정보를 출력하는 경우
https://www.programiz.com/sql/min-and-max
https://www.techonthenet.com/sql/max.php
select max(DATETIME) from ANIMAL_INS;
SELECT min(DATETIME) from ANIMAL_INS;
SELECT count(distinct name)
from ANIMAL_INS;