What are the BETWEEN and NOT BETWEEN expressions?

What are the BETWEEN and NOT BETWEEN expressions?

Rating:

The BETWEEN expression in EJB-QL represents a value in the specified range. The syntax of the BETWEEN expression used in the SELECT clause is as follows:

SELECT OBJECT(e) FROM EMPLOYEE e WHERE e.salary BETWEEN 2000 and 3000

The query will return all the employees from the EMPLOYEE table whose salary is between 2000 and 3000. The upper and lower ranges are included.

The NOT BETWEEN expression in EJB-QL represents all values that do not lie in the specified range. The syntax of the NOT BETWEEN expression used in the SELECT clause is as follows:

SELECT OBJECT(e) FROM EMPLOYEE e WHERE e.salary NOT BETWEEN 2000 and 3000

The query will return all the employees from the EMPLOYEE table whose salary is either below 2000 or above 3000.

Rating: