SQL arithmetic operators
Arithmetic operators take two numeric values (either literals or variables) and perform a calculation that returns a single numeric value.
| Operator | Description | |
|---|---|---|
+ | Addition | |
- | Subtraction | |
* | Multiplication | |
/ | Division | |
% | Modulo |
+
The + operator adds two operands together and returns the sum.
SELECT 1 + 2
| int64(1) + int64(2) |
|---|
| 3 |
-
The - operator subtracts the right operand from the left operand and returns
the difference.
SELECT 4 - 2
| int64(4) - int64(2) |
|---|
| 2 |
*
The * operator multiplies two operands together and returns the product.
SELECT 2 * 3
| int64(2) * int64(3) |
|---|
| 6 |
/
The / operator divides the left operand by the right operand and returns the quotient.
SELECT 6 / 3
| int64(6) / int64(3) |
|---|
| 2 |
%
The % (modulo) operator divides the left operand by the right operand and returns the
remainder. If the left operand is not divisible by the right operand, it returns
the left operand.
SELECT 8 % 3
| Int64(8) % Int64(3) |
|---|
| 2 |
SELECT 3 % 8
| Int64(3) % Int64(8) |
|---|
| 3 |
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB 3 Core and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.