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.