BETWEEN Expressions
BETWEEN Expressions
TABLE 272
Query Language Order Precedence
(Continued)
Type
Precedence Order
Comparison
=
>
>=
<
<=
<>
(not equal)
[NOT] BETWEEN
[NOT] LIKE
[NOT] IN
IS [NOT] NULL
IS [NOT] EMPTY
[NOT] MEMBER OF
Logical
NOT
AND
OR
BETWEEN
Expressions
A BETWEEN expression determines whether an arithmetic expression falls within a range of
values.
These two expressions are equivalent:
p.age BETWEEN 15 AND 19
p.age >= 15 AND p.age <= 19
The following two expressions are also equivalent:
p.age NOT BETWEEN 15 AND 19
p.age < 15 OR p.age > 19
If an arithmetic expression has a NULL value, then the value of the BETWEEN expression is
unknown.
IN
Expressions
An IN expression determines whether or not a string belongs to a set of string literals, or
whether a number belongs to a set of number values.
Full Query Language Syntax
Chapter 27 · The Java Persistence Query Language
753
