1 of 1

NEG

This page describes the NEG function in Lenses SQL.

NEG(numExpr)

Returns the negative value of an expression it has to evaluate to a number type.

Available in:

Processors

SQL Studio

Sample code:

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

Output:

{
  "value": {
    "NEG": -95.95,
    "float": 95.95
  }
}

This page describes the NEG function in Lenses SQL.

NEG(numExpr)

Returns the negative value of an expression it has to evaluate to a number type.

Available in:

Processors

SQL Studio

Sample code:

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

Output:

{
  "value": {
    "NEG": -95.95,
    "float": 95.95
  }
}