MySQL max() function

The MySQL max() function is used to return the maximum value of an expression. It is used when you need to get the maximum value from your table.

Syntax:

SELECT MAX(aggregate_expression)
FROM tables
[WHERE conditions];

Parameter explanation

aggregate_expression: It specifies the column or expression, from which the maximum value will be returned.

table_name: It specifies the tables, from where you want to retrieve records. There must be at least one table listed in the FROM clause.

WHERE conditions: It is optional. It specifies the conditions that must be fulfilled for the records to be selected.

Consider a table named "employees", having the following data.

Execute the following query:

SELECT MAX (working_hours) AS "Maximum working hours"
FROM employees;

Output:

Next TopicMySQL first()