New

The executive guide to generative AI

Read more
About usPartnersSupport|Login
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 »
Elastic Docs ›Elasticsearch Guide [8.x] ›SQL ›Functions and Operators

Math Operators

edit
IMPORTANT: This documentation is no longer updated. Refer to Elastic's version policy and the latest documentation.

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 »
Was this helpful?
Feedback