www.mimer.com/developer

Comparison and Relational Operators

---

Comparison operators are used to compare operands in basic and quantified predicates. Relational operators are used to compare operands in all other predicates. see Predicates.

Both comparison and relational operators perform essentially similar functions. The comparison operators are however common to most programming languages, while the relational operators are more or less specific to SQL.

Comparison Operators

Comparison operator	Explanation
=	equal to
<>	not equal to
<	less than
<=	less than or equal to
>	greater than
>=	greater than or equal to

Quantifiers:

• ALL
• SOME
• ANY

Relational Operators

Relational operators
BETWEEN
EXISTS
IN
IS
LIKE
OVERLAPS

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se