9.1. Query API9.1.1. Parameters9.1.2. Date Parameters9.1.3. Paging Results9.1.4. Hints9.1.5. FlushMode9.2. EJB QL9.2.1. Abstract Schema Names9.2.2. Simple Queries9.2.3. Selecting Entity and Relationship Properties9.2.4. Constructor Expressions9.2.5. The IN Operator and INNER JOIN9.2.6. LEFT JOIN9.2.7. Fetch Joins9.2.8. Using DISTINCT9.2.9. The WHERE Clause and Literals9.2.10. The WHERE Clause and Operator Precedence9.2.11. The WHERE Clause and Arithmetic Operators9.2.12. The WHERE Clause and Logical Operators9.2.13. The WHERE Clause and Comparison Symbols9.2.14. The WHERE Clause and Equality Semantics9.2.15. The WHERE Clause and BETWEEN9.2.16. The WHERE Clause and IN9.2.17. The WHERE Clause and IS NULL9.2.18. The WHERE Clause and IS EMPTY9.2.19. The WHERE Clause and MEMBER OF9.2.20. The WHERE Clause and LIKE9.2.21. Functional Expressions9.2.21.1. Functional expressions in the WHERE clause9.2.21.2. Functions returning dates and times9.2.21.3. Aggregate functions in the SELECT clause9.2.21.3.1. COUNT (identifier or path expression)9.2.21.3.2. MAX( path expression), MIN( path expression)9.2.21.3.3. AVG( numeric ), SUM( numeric)9.2.21.3.4. DISTINCT, nulls, and empty arguments9.2.22. The ORDER BY Clause9.2.23. GROUP BY and HAVING9.2.24. Subqueries9.2.24.1. ALL, ANY, SOME9.2.24.2. EXISTS9.2.25. Bulk UPDATE and DELETE9.3. Native Queries9.3.1. Scalar Native Queries9.3.2. Simple Entity Native Queries9.3.3. Complex Native Queries9.3.3.1. Native queries with multiple entities9.3.3.2. Mixed scalar and entity results9.4. Named Queries9.4.1. Named Native Queries