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;