...
Syntax | Result | Description | Examples |
---|---|---|---|
number + numbernumeric_expression + numeric_expression | number | Adds two numeric expressions. |
|
number - numbernumeric_expression - numeric_expression | number | Subtracts a numeric expression from another. |
|
number * numbernumeric_expression * numeric_expression | number | Multiplies two numeric expressions. |
|
number / numbernumeric_expression / numeric_expression | number | Divides a numeric expression by another. | |
numeric_expression % numbernumeric_expression | number | Computes the remainder of the division between two numeric expressions. |
...
Syntax | Result | Description | Examples |
---|---|---|---|
COUNT(requirement_list) | number | ||
SUM(number, requirementsnumeric_expression, requirement_list) | number | ||
AVG(number, requirements)numeric_expression, requirement_list) | number | ||
MAX(number, requirements)numeric_expression, requirement_list) | number | ||
MIN(number, requirements)numeric_expression, requirement_list) | number |
Boolean expressions
Syntax | Result | Description | Examples |
---|---|---|---|
NOT boolean_expression | boolean | ||
boolean_expression AND boolean_expression | boolean | ||
boolean_expression OR boolean_expression | boolean | ||
| boolean | ||
| boolean | ||
number > numbernumeric_expression > numeric_expression | boolean | ||
number numeric_expression >= numbernumeric_expression | boolean | ||
number < numbernumeric_expression < numeric_expression | boolean | ||
number numeric_expression <= number numeric_expression | boolean | ||
| boolean | ||
expression IS NULL | boolean | ||
expression IS NOT NULL | boolean |