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
