NOTE: You are looking at documentation for an older release. For the latest information, see the current release documentation.
Math Operators
editMath Operators
editPerform mathematical operations affecting one or two values. The result is a value of numeric type.
Add (+)
editSELECT 1 + 1 AS x;
Subtract (infix -)
editSELECT 1 - 1 AS x;
Negate (unary -)
editSELECT - 1 AS x;
Multiply (*)
editSELECT 2 * 3 AS x;
Divide (/)
editSELECT 6 / 3 AS x;
Modulo or Remainder(%)
editSELECT 5 % 2 AS x;