MIN
MAX
GROUP_CONCAT
최댓값을 반환합니다.
MAX(expr)
아래 값을 입력하면 예제에 즉시 반영됩니다.
department_id
salary
max_salary
employees
SELECT department_id, MAX(salary) AS max_salary FROM employees GROUP BY department_id;