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