Mysql Min Max. The min function returns the minimum value in a set of values. The min function is very useful in some scenarios such as finding the smallest number selecting the least expensive product or getting the lowest credit limit.
Here is the basic syntax of the max function. These are the functions in mysql that performs some calculation on a set of values and then returns a single value. In this page we are going to discuss how the group by clause along with the sql min can be used to find the minimum value of a column over each group.
Basic usage of min and max sql functions can provide each customers monthly highest and lowest sales order amount values when used in combination with group by clause as in below sql query.
In this case mysql does a single key lookup for each min or max expression and replaces it with a constant. Introduction to mysql min function. Whereas min is an aggregate function which returns the smallest value in the given column. The mysql max function returns the maximum value in a set of values.
