EJB Query Language « JPA « Java

Home Java 1. 2D Graphics GUI 2. 3D 3. Advanced Graphics 4. Ant 5. Apache Common 6. Chart 7. Class 8. Collections Data Structure 9. Data Type 10. Database SQL JDBC 11. Design Pattern 12. Development Class 13. EJB3 14. Email 15. Event 16. File Input Output 17. Game 18. Generics 19. GWT 20. Hibernate 21. I18N 22. J2EE 23. J2ME 24. JavaFX 25. JDK 6 26. JDK 7 27. JNDI LDAP 28. JPA 29. JSP 30. JSTL 31. Language Basics 32. Network Protocol 33. PDF RTF 34. Reflection 35. Regular Expressions 36. Scripting 37. Security 38. Servlets 39. Spring 40. Swing Components 41. Swing JFC 42. SWT JFace Eclipse 43. Threads 44. Tiny Application 45. Velocity 46. Web Services SOA 47. XML

Java » JPA » EJB Query Language   1. Simple Select statement 2. Select Two Entities 3. Get Two Properties From Entity 4. Get String Properties From Entities 5. Retrieve Inner Entity 6. Retrieve in One to Many Mapping 7. Reference Two Entities In Where Clause 8. Retrieve Entity Fields 9. Create Sub Query With Entities 10. Use OrderBy Clause 11. Order By Two Columns 12. Order By Descending 13. EJB QL: Having clause 14. All Operator in EJB QL 15. EJB QL: Where Clause With SubQuery 16. Using Exists clause 17. Aggregate function: Count And Avg 18. EJB QL: Concat Function With Substring 19. Aggregate function: AVG 20. Use Size Function To Check Collection 21. Use In With One To One Mapping 22. Not IN 23. Not Exist With Subquery 24. Not Empty 25. Match Single Character And Multiple Characters 26. MemberOf function 27. OBJECT Funtion 28. Left Join 29. Join Two Entities in One To One Mapping 30. Join Two Entities in Many To One Mapping 31. Join Three Entities 32. Join Fetch 33. Using In function 34. Group By With Count 35. Escape wildcard 36. Entity Join With Condition 37. Empty Value 38. Distinct function 39. Count Entities 40. Count Collection 41. Conditional operator: AND 42. Between...And 43. AVG With GroupBy clause 44. Any With Subquery 45. Subquery in EJB QL