This page describes the syntax to perform calculations.
Arithmetic expressions
Syntax | Result | Description | Examples |
---|---|---|---|
number + number | number | Adds two numeric expressions. |
|
number - number | number | Subtracts a numeric expression from another. |
|
number * number | number | Multiplies two numeric expressions. |
|
number / number | number | Divides a numeric expression by another. | |
numeric % number | number | Computes the remainder of the division between two numeric expressions. |
Aggregation expressions
Syntax | Result | Description | Examples |
---|---|---|---|
SUM(number, requirements) | |||
AVG(number, requirements) | |||
MAX(number, requirements) | |||
MIN(number, requirements) | |||
Boolean expressions
Syntax | Result | Description | Examples |
---|---|---|---|
NOT boolean | boolean | ||
boolean AND boolean | boolean | ||
boolean OR boolean | boolean | ||
| boolean | ||
| boolean | ||
number > number | boolean | ||
number >= number | boolean | ||
number < number | boolean | ||
number <= number | boolean | ||
| boolean | ||
expression IS NULL | boolean | ||
expression IS NOT NULL | boolean |