min

Returns the lowest value in a column.

Syntax

min(expression)

expression – is a column name, constant, function, any combination of column names, constants, and functions connected by arithmetic or bitwise operators, or a subquery. With aggregates, an expression is usually a column name.

Example 1 – Returns the lowest value in the price column:

select min(price) from titles
    where type = "psychology"

------------------------
                   7.00

You can use min with numeric, character, time, and datetime columns, but not with bit columns. With character columns, min finds the lowest value in the sort sequence. min implicitly converts char datatypes to varchar, and unichar datatypes to univarchar, stripping all trailing blanks. min ignores null values. distinct is not available, since it is not meaningful with min.
min preserves the trailing zeros in varbinary data.
min returns a varbinary datatype from queries on binary data.
unichar data is collated according to the default Unicode sort order.
The SAP ASE server goes directly to the first qualifying row for min when there is an index on the aggregated column, unless:
- The expression is not a column.
- The column is not the first column of an index.
- There is another aggregate in the query.
- There is a group by clause.

ANSI SQL – Compliance level: Transact-SQL extension.

Any user can execute min.