Specify a comparison of two row values.


<comparison predicate> ::=
<comparison predicate part 2> ::= <comp op> <row value predicand>
<comp op> ::=


The degree of the row value predicands shall be 1.
The data types shall be comparable.
The predicate evaluates to TRUE if the comparison criteria is met, else to FALSE.
If either of the row values are null, then the predicate evaluates to UNKNOWN.


1) The following example selects students who are not from California:

       SELECT studentName, state

       FROM students

       WHERE state <> 'CA'

2) The following example selects teachers who earn $35,000 or more:

       SELECT teacherName, salary

       FROM teachers

       WHERE salary >= 35000


SQL:2003 standard


Core SQL

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | Predicates