ROUND

This page describes the ROUND function in Lenses SQL.

ROUND(numExpr)

Returns the closest integer of an expression, with ties rounding towards positive infinity.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

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

Output:

{
  "value": {
    "ROUND": 96,
    "float": 95.95
  }
}