MIN

This page describes the MIN function in Lenses SQL.

MIN(numExpr1,numExpr2,numExpr3)

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

Available in:

Processors	SQL Studio
✓	✓

Sample code:

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

Output:

{
  "value": {
    "MIN": 19.7
  }
}