MIN
Description
This function calculates the minimum value per group. MIN can be applied on any data type.
Syntax
MIN ( table.column )
NULL handling
NULL values are ignored, so they do not influence the result. If all the values of a group are NULL, the result for this group is also NULL.
Examples
[1] Minimum of column. | ||||||||||
| ||||||||||
|
[2] Get the minimum value by country. | ||||||||||||||||||||||||||
| ||||||||||||||||||||||||||
|
[3] Get the minimum value mixed with nulls, grouped by country. | ||||||||||||||||||
| ||||||||||||||||||
|