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:

snippet

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:

snippet

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

Output:

Related Tutorial

1 MySQL count() Function

2 MySQL sum() function

3 MySQL avg() function

4 MySQL min() function

5 MySQL max() function

6 MySQL GROUP_CONCAT() Function

7 MySQL first function

8 MySQL last function

Try it

Contents +