0 votes
in MariaDB by
What is the usage of MAX() function in MariaDB?

1 Answer

0 votes
by
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:
...