Min

Return the minimum value from the result set of a query. (SQL).

Syntax
      Min (expression)

Key
   expression   A field or formula that evaluates to a numeric expression.

Use the Min function in the access query builder by clicking the Totals toolbar button:

Σ

The Min function is used in conjunction with the Group By clause.

Example

Select Min(price) 
from T_Sales 
Group By Supplier;

“Winning takes talent; to repeat takes character.” ~ John Wooden

Related:

DMin - Return the minimum value from a set of records.
Avg (SQL) - Average
Count (SQL) - Count records
Max (SQL) - Return the maximum value from a query.
Partition (SQL) - Locate a number within a range.
Sum (SQL) - Add up the values in a query result set.


© Copyright SS64.com 1999-2014
Some rights reserved