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;