Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

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:

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
Mimer SQL Reference Manual TOC PREV NEXT INDEX