Java Persistence API (JPA) Extensions Reference for EclipseLink, Release 2.4
When performing multiple queries, use
EXCEPT to remove the results of a second query from the results of a first query.
EXCEPT function is database independent, but requires database support.
Example 3-4 shows how to use this JPQL extension.
Example 3-4 Using EXCEPT EQL
SELECT e FROM Employee e EXCEPT SELECT e FROM Employee e WHERE e.salary > e.manager.salary
For more information, see: