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;