IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.

› › ›

Math Operators

edit

Math Operators

edit

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;

« Logical Operators Cast Operators »