MAX()

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

Syntax

MAX( expression, expression [, ...] )

If any parameter is NULL, the function returns NULL.

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

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