MIN()

Scalar. Returns the minimum value from a list of expressions.

Syntax

MIN( expression, expression [, ...] )

If any parameter is NULL, the function returns NULL.

The following example calculates the minimum value of three columns in the Orders stream:

INSERT INTO OutStream
SELECT MIN(Orders.line1price, Orders.line2price, Orders.line3Price)
FROM Orders;