This documentation contains work-in-progress information for future Elastic Stack and Cloud releases. Use the version selector to view supported release docs. It also contains some Elastic Cloud serverless information. Check out our serverless docs for more details.

« Logical Operators Cast Operators »

› › ›

Math Operators

Math Operators

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

`Add (+)`

SELECT 1 + 1 AS x;

`Subtract (infix -)`

SELECT 1 - 1 AS x;

`Negate (unary -)`

SELECT - 1 AS x;

`Multiply (*)`

SELECT 2 * 3 AS x;

`Divide (/)`

SELECT 6 / 3 AS x;

`Modulo or Remainder(%)`

SELECT 5 % 2 AS x;

« Logical Operators Cast Operators »