MySQL MAX() Function
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];
SELECT MAX(aggregate_expression) FROM tables [WHERE conditions];