Math operators [sql-operators-math]

Perform mathematical operations affecting one or two values. The result is a value of numeric type.

Add (+) [sql-operators-plus]

SELECT 1 + 1 AS x;

Subtract (infix -) [sql-operators-subtract]

SELECT 1 - 1 AS x;

Negate (unary -) [sql-operators-negate]

SELECT - 1 AS x;

Multiply (*) [sql-operators-multiply]

SELECT 2 * 3 AS x;

Divide (/) [sql-operators-divide]

SELECT 6 / 3 AS x;

Modulo or Remainder(%) [sql-operators-remainder]

SELECT 5 % 2 AS x;