Comparison Predicate

Wed, 03/04/2009 - 20:02 |  hdanzl

Specify a comparison of two row values.


Syntax

<comparison predicate> ::=
<comparison predicate part 2> ::= <comp op> <row value predicand>
<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
‹ PredicatesupBetween Predicate ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | Predicates

Powered by Drupal and Drupal Theme created with Artisteer.