NexusDB Guide > SQL Reference > Predicates

NexusDB V3 Manual

Equivalent Predicate

Compares two values for equivalence.

Syntax

<equivalent predicate> ::=

Notes

§	The data types shall be comparable.

§	The predicate evaluates to TRUE if the two values are equal, else to FALSE.

§	Null values are considered equal in this predicate.

Examples

1)	The following example selects students from Newport:

SELECT studentID, studentName, city

FROM students

WHERE EQUIVALENT ( city, 'Newport' )

Conformance

NexusDB extensions

EQUIVALENT predicate

nexus_logo