Explanation and Example
you specify with the ESCAPE clause.
LIKE '%=_' ESCAPE '='
used, Derby compares one character
at a time for non-metacharacters.
This is different than the way Derby
processes = comparisons. The
comparisons with the = operator
compare the entire character string
on left side of the = operator with
the entire character string on the
right side of the = operator. For more
information, see Character-based
collation in Derby in the Derby
Developer's Guide.
is between the second and third
operands. The second operand
must be less than the third operand.
Applicable only to types to which <=
and >= can be applied.
DATE('1998-02-26') AND
DATE('1998-03-01')
BETWEEN Expression
AND Expression
of values. Returns TRUE if the left
expression's value is in the result of
the table subquery or in the list of
values. Table subquery can return
multiple rows but must return a single
column.
(SELECT booking_date FROM
HotelBookings WHERE
rooms_available = 0)
Expression [ NOT ]
IN
Expression [ NOT ]
IN ( Expression
[, Expression ]*
)
}
Returns TRUE if the table subquery
returns any rows, and FALSE if it
returns no rows. Table subquery can
return multiple columns (only if you
use * to denote multiple columns) and
rows.
(SELECT *
FROM Flights
WHERE dest_airport = 'SFO'
AND orig_airport = 'GRU')
comparison
comparison operator (<, =, >, <=,
ComparisonOperator