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

- © 2010, Oracle Corporation and/or its affiliates