SQL MIN()

Purpose

Returns a minimum value in a SELECT statement

Syntax

MIN(<expr1> [, <expr2> [, ...]])

See Also

AGGREGATES, AVG(), COUNT(), MAX(), SELECT, SUM()

Description

Returns the minimum value of <expr1> or the list of expressions (list supported from v6.0).

The expressions can be of the following data types:

• Numeric
• Date
• Character (from v6.0)
• Currency (from v6.0)
• Datetime (from v6.0)

Example

open database southwind
select min(orderdate,requireddate,shippeddate) from orders
select min(companyname) from customers