Math Operators
Perform mathematical operations affecting one or two values. The result is a value of numeric type.
SELECT 1 + 1 AS x;
SELECT 1 - 1 AS x;
SELECT - 1 AS x;
SELECT 2 * 3 AS x;
SELECT 6 / 3 AS x;
SELECT 5 % 2 AS x;
Perform mathematical operations affecting one or two values. The result is a value of numeric type.
SELECT 1 + 1 AS x;
SELECT 1 - 1 AS x;
SELECT - 1 AS x;
SELECT 2 * 3 AS x;
SELECT 6 / 3 AS x;
SELECT 5 % 2 AS x;