Operators are symbols and keywords that specify an operation to be performed on one or more value expressions.


Arithmetic operators

The arithmetic operators perform operations on numeric values.

Operator

Symbol

Operation

<addition operator>

+

Addition

<subtraction operator>

-

Subtraction

<multiplication operator>

*

Multiplication

<division operator>

/

Division

Note: The addition (+) and subtraction (-) operators are also used in arithmetic operations on datetime values.

See also: Numeric Value Functions.


Concatenation operators

The concatenation operator is used to concatenate string values.

Operator

Symbol

Operation

<concatenation operator>

||

String concatenation

Note: The arithmetic addition (+) operator can be used as an alternate string concatenation operator.

See also: String Value Functions.


Comparison operators

The comparison operators are used in some predicates to specify comparison tests.

Operator

Symbol

Operation

<equals operator>

=

Equal to

<not equals operator>

<>

Not equal to

<less than operator>

<

Less than

<greater than operator>

>

Greater than

<less than or equals operator>

<=

Less than or equal to

<greater than or equals operator>

>=

Greater than or equal to

Note: The equals sign (=) is also used as an assignment operator.


Boolean operators

The boolean operators are used to combine predicates in search conditions.

Operator

Keyword

Operation

<boolean NOT operator>

NOT

Invert the result of the boolean test

<boolean AND operator>

AND

Test if both predicates are TRUE

<boolean OR operator>

OR

Test if either of the predicates is TRUE

Note: Check the truth tables to see how combined boolean expressions are evaluated.


Assignment operator

The equals sign is used for value assignments.

Operator

Symbol

Operation

<assignment operator>

=

Value assignment


Operator precedence

Operator precedence determines the order in which operations are performed during the execution of a complex value expression with multiple operators.

Operators are evaluated in the following order, ranked from highest to lowest precedence level:

* (multiplication), / (division)
+ (addition), - (subtraction)
||, + (concatenation)
=, <>, <, >, <=, >= (comparison operators)
NOT
AND
OR

Operators on the same precedence level are evaluated left to right based on their position in the value expression.

If a value expression has nested parentheses, the innermost expression is evaluated first.

Tip: Instead of relying on the defined operator precedence, it is recommended to use parentheses to explicitly specify the order of operations in complex value expressions with many operators. All operations inside parentheses are evaluated first to yield a single value before that value is used as an operand in other operations.


Conformance

SQL:2003 standard

NexusDB extensions

-

-

Core SQL

Plus sign as string concatenation operator

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Language Elements