Using the Relational Data Framework › Use Expressions and Functions › Numeric Aggregate Functions › MIN Function

MIN Function

The MIN function returns the minimum value in a specified column. For example, to find the minimum cost of a workstation in the WORKSTATIONS table, use this statement:

OPSQL SELECT MIN (COST) FROM WORKSTATIONS

This yields a result of 1200.

You can also combine the MAX and MIN functions in a single statement, as follows:

ADDRESS SQL
"SELECT MAX (COST), MIN (COST) FROM WORKSTATIONS"

This yields a result of 4840 and 1200.

As with MAX, the MIN function is not limited to numeric data. When used with character data, MIN means first in alphabetical order.