#mysql max function

MySQL MIN() and MAX() Functions

MySQL MIN() and MAX() Functions

  The MIN() function returns the smallest value of the selected column and the MAX() function returns the largest value of the selected column.

MIN() Syntax SELECT MIN(column_name) FROM table_name WHERE condition; MAX() Syntax SELECT MAX(column_name) FROM table_name WHERE condition;