MAX(expression)

Description: Returns the maximum value of expression. Generally used with GROUP BY clause, but otherwise operates on all rows returned.

May take a string argument, returning the maximum string value.

Example:

SELECT city_name, MAX(temperature)
  FROM weather
  GROUP BY city_name

See also: MIN()