The BETWEEN Expression

SELECT DISTINCT p
FROM Player p
WHERE p.salary BETWEEN :lowerSalary AND :higherSalary

• Data retrieved: The players whose salaries fall within the range of the specified salaries.

• Description: This BETWEEN expression has three arithmetic expressions: a persistent field (p.salary) and the two input parameters (:lowerSalary and :higherSalary). The following expression is equivalent to the BETWEEN expression:

  p.salary >= :lowerSalary AND p.salary <= :higherSalary

• See also: BETWEEN Expressions.