MAX

This page describes the MAX function in Lenses SQL.

MAX(numExpr1,numExpr2,numExpr3)

Returns the maximum element from an arbitrary number of given elements.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT MAX(integer, float) 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "MAX": 16550
  }
}