MIN

Returns the minimum value in the expression. Ignores all NULL values.

Syntax

MIN ( [ DISTINCT ] expression  )  

Arguments

expression
An expression that is a numeric, date/time, or literal.

DISTINCT Specifies that each unique value is considered. DISTINCT is not meaningful with MIN.

Return Type

Returns a value same as expression.

Examples

This example finds the lowest (minimum) price in the pricing blockchain.

SELECT MIN(price) FROM pricing;

Response:

MIN(PRICE) [FLOAT32]    
4.91