Close

JPA Tutorials - Java Persistence Query Language (JPQL)
  1. SELECT-FROM-WHERE Query Example
  2. ORDER BY ASC/DESC Clause Example
  3. Eliminating Duplicate Values by using SELECT-DISTINCT statement
  4. Using Literals in JPQL
  5. JPQL INNER JOIN
  6. JPQL LEFT OUTER JOIN
  7. JPQL LEFT OUTER JOIN ON Condition
  8. JPQL FETCH JOIN
  9. JPQL BETWEEN Expression Examples
  10. JPQL IN Expression Examples
  11. JPQL LIKE Expression Examples
  12. JPQL IS NULL expression
  13. JPQL IS EMPTY Expression
  14. JPQL MEMBER OF Expression
  15. JPQL Aggregate Functions Examples
  16. JPQL GROUP BY and HAVING Clauses
  17. JPQL Subquery in WHERE AND HAVING Clauses
  18. JPQL EXISTS Expression
  19. JPQL ALL and ANY Expressions
  20. JPQL Polymorphic Queries
  21. JPQL Downcasting With TREAT Operator
  22. JPQL String Functions
  23. JPQL Arithmetic Functions
  24. JPQL Datetime Functions
  25. Calling Database Functions
  26. Different cases involving collection in WHERE clause
  27. JPQL Case Expressions
  28. JPQL UPDATE Statements
  29. JPQL DELETE Statements
  30. Using TypedQuery
  31. Constructor Expressions in the SELECT Clause
  32. Returning Tuple results
  33. Using keywords KEY, VLUE, ENTRY to navigate Map element collections