At first glance, the MySQL MAX()
and GREATEST()
functions perform a similar operation. They both return the maximum value from a range of values. However, there’s a difference between these two functions.
The best way to see the difference between these two functions is to compare their syntax.