Skip to main content

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