NexusDB Guide > SQL Reference > Predicates

NexusDB V3 Manual

Odd Predicate

Specify a test for odd numbers.

Syntax

<odd predicate> ::= ODD ( <numeric value expression> )

Notes

§	The data type shall be numeric.

§	The predicate evaluates to TRUE if the value is an odd number, else to FALSE.

§	If the given value is null, then the predicate evaluates to UNKNOWN.

Examples

1)	The following example selects students with odd studentID:

SELECT studentID, studentName

FROM students

WHERE ODD( studentID )

Conformance

NexusDB extensions

ODD predicate

nexus_logo