1 of 1

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
  }
}

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
  }
}