Returns the maximum value.
Syntax
MAX(expr)Example
Enter values below to update the example in real time.
department_id→salary→max_salary→employees→SELECT department_id, MAX(salary) AS max_salary
FROM employees
GROUP BY department_id;
Returns the maximum value.
MAX(expr)Enter values below to update the example in real time.
department_id→salary→max_salary→employees→SELECT department_id, MAX(salary) AS max_salary
FROM employees
GROUP BY department_id;