MariaDB MAX() function is used to retrieve the maximum value of the expression.
MAX () can take string argument too, in which case it returns the maximum string values.
MAX () returns NULL if there were no matching rows.
Syntax:
SELECT MAX(aggregate_expression)
FROM tables
[WHERE conditions];
Example
We have a "student" table
MariaDB interview questions
To list out the student name with maximum score:
MariaDB interview questions
To check maximum string name: