SQL Language Elements
Search ConditionsRelational Operators
|
|
|
Relational operators specify how FairCom DB SQL compares expressions in basic and quantified predicates.
Syntax
relop ::
=
| <> | != | ^=
| <
| <=
| >
| >=
Relational Operator |
Predicate |
|---|---|
= |
True if the two expressions are equal. |
<> | != | ^= |
True if the two expressions are not equal. The operators != and ^= are equivalent to <>. |
< |
True if the first expression is less than the second expression. |
<= |
True if the first expression is less than or equal to the second expression |
> |
True if the first expression is greater than the second expression. |
>= |
True if the first expression is greater than or equal to the second expression. |
Refer to Basic Predicate and Quantified Predicate for more information.
