FLOOR

This page describes the FLOOR function in Lenses SQL.

FLOOR(numExpr)

Returns the largest value not greater than the argument.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT 
    FLOOR(float),
    float 
FROM numbers-data
LIMIT 2;

Output:

{
  "value": {
    "FLOOR": 19,
    "float": 19.7
  }
}
{
  "value": {
    "FLOOR": 83,
    "float": 83.82
  }
}