Numeric

This page describes how to use numeric functions in Lenses SQL Processors.

%

The remainder operator (%) computes the remainder after dividing its first operand by its second i.e. numExpr % numExpr

/

Divides one number by another (an arithmetic operator) i.e. numExpr / numExpr

-

Subtracts one number from another (an arithmetic operator) i.e. numExpr - numExpr

*

Multiplies one number with another (an arithmetic operator) i.e. numExpr * numExpr

+

Adds one number to another (an arithmetic operator) i.e. numExpr + numExpr

- (negative)

Returns the negative of the value of a numeric expression (a unary operator) i.e. -numExpr

Last updated

Logo

2024 © Lenses.io Ltd. Apache, Apache Kafka, Kafka and associated open source project names are trademarks of the Apache Software Foundation.