ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

MIN function [Aggregate]

Function 

Returns the minimum expression value found in each group of rows.

Syntax 

MIN ( expression
| DISTINCT column name )

Parameters 

expression    The expression for which the minimum value is to be calculated. This is commonly a column name.

DISTINCT column-name    Returns the same as MIN( expression ), and is included for completeness.

Usage 

Rows where expression is NULL are ignored. Returns NULL for a group containing no rows.

Standards and compatibility 

• SQL/92    SQL/92 compatible.

• SQL/99    Core feature.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

MAX function [Aggregate]

Example 

The following statement returns the value 24903.000, representing the minimum salary in the employee table.

SELECT MIN( salary )
FROM employee