SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—540440-003
6-81
Predicates
CONTROL QUERY DEFAULT attributes determine the number and physical location
of the partitions. For values and syntax of these defaults, see Partition Management on
page 10-51.
For more information on this feature, see Creating Partitions Automatically on
page 2-89.
Predicates
A predicate determines an answer to a question about a value or group of values. A
predicate returns true, false, or, if the question cannot be answered, unknown. Use
predicates within search conditions to choose rows from tables or views.
See the individual entry for a predicate or predicate group.
BETWEEN Predicate
Considerations for BETWEEN
Examples of BETWEEN
BETWEEN Predicate on page 6-81 Determines whether a sequence of values is within
a range of sequences of values.
Comparison Predicates
on page 6-84
( =, <>, <, >, <=, >= )
Compares the values of sequences of expressions,
or compares the values of sequences of row values
that are the result of row subqueries.
EXISTS Predicate
on page 6-88 Determines whether any rows are selected by a
subquery. If the subquery finds at least one row that
satisfies its search condition, the predicate
evaluates to true. Otherwise, if the result table of the
subquery is empty, the predicate is false.
IN Predicate
on page 6-90 Determines if a sequence of values is equal to any
of the sequences of values in a list of sequences.
LIKE Predicate
on page 6-93 Searches for character strings that match a pattern.
NULL Predicate
on page 6-95 Determines whether all the values in a sequence of
values are null.
Quantified Comparison Predicates
on
page 6-97
( ALL, ANY, SOME )
Compares the values of sequences of expressions
to the values in each row selected by a table
subquery. The comparison is quantified by ALL,
SOME, or ANY.
Rowset Predicates
on page 6-100 A predicate that contains a rowset expression.