Returns the smallest value of the field in the resultset/group.

 

Example:

With the sample data set:

 

Field1	Field2	Field3
23	10	17
17	10	9
5	12	15

 

 

SELECT MIN(Field1) returns 5.