MySQLAggregate FunctionsMIN
AVG

MINAggregate Functions

MAX

Returns the minimum value.

Syntax

MIN(expr)

Example

Enter values below to update the example in real time.

department_id
salary
min_salary
employees
SELECT department_id, MIN(salary) AS min_salary
FROM employees
GROUP BY department_id;