NexusDB Guide > SQL Reference > Predicates

NexusDB V3 Manual

Comparison Predicate

Specify a comparison of two row values.

Syntax

<comparison predicate> ::=

<comp op> ::=

Notes

§	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.

Examples

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

Conformance

SQL:2003 standard

Core SQL

nexus_logo