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.
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.
MySQL max() function example
Consider a table named "employees", having the following data.
Execute the following query: