MySQL/ MIN, MAX

MIN

• 특정 컬럼의 최소값 조회

SELECT MIN(COLUMN_NAME)
FROM TABLE_NAME
WHERE CONDITION;

SELECT MIN(Price) AS SmallestPrice
FROM Products;

MAX

• 특정 컬럼의 최대값 조회

SELECT MAX(COLUMN_NAME)
FROM TABLE_NAME
WHERE CONDITION;

SELECT MAX(Price) AS LargestPrice
FROM Products;