MariaDB MAX() function is used to retrieve the maximum value of the expression.

Syntax:

SELECT MAX(aggregate_expression)

FROM tables

[WHERE conditions];