SpringData : is it possible to have subqueries in the Query annotation?

by

No, it is not possible to have subquery in the select clause in JPQL query.

JPQL supports subqueries in WHERE and HAVING clauses. It can be (at least) part of ANY, SOME, ALL, IN, EXIST expressions, and of course it can be used normal conditional expressions:

SELECT a
FROM A a
WHERE a.val = (SELECT b.someval 
               FROM B b 
               WHERE b.someotherval=3)

More Related Contents:

  1. Spring Data JPA and Exists query
  2. Dynamic spring data jpa repository query with arbitrary AND clauses
  3. How are Spring Data repositories actually implemented?
  4. What is this spring.jpa.open-in-view=true property in Spring Boot?
  5. setMaxResults for Spring-Data-JPA annotation?
  6. Spring Boot – Cannot determine embedded database driver class for database type NONE
  7. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  8. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  9. What’s the difference between Spring Data’s MongoTemplate and MongoRepository?
  10. Handling soft-deletes with Spring JPA
  11. How to maintain bi-directional relationships with Spring Data REST and JPA?
  12. Implementing custom methods of Spring Data repository and exposing them through REST
  13. Parameter in like clause JPQL
  14. How to do a Mongo aggregation query in Spring Data?
  15. Spring-Data FETCH JOIN with Paging is not working
  16. Limit number of results in JPQL
  17. Java SE + Spring Data + Hibernate
  18. Filtering data with Spring boot CrudRepository
  19. Why use returned instance after save() on Spring Data JPA Repository?
  20. How to use @Transactional with Spring Data?
  21. Are you supposed to have one repository per table in JPA?
  22. Delete Not Working with JpaRepository
  23. How to store @Query sql in external file for CrudRepository?
  24. Spring Data JPA find by embedded object property
  25. Table ‘DBNAME.hibernate_sequence’ doesn’t exist
  26. PageRequest constructors have been deprecated
  27. What’s the difference between the IN and MEMBER OF JPQL operators?
  28. Best way of handling entities inheritance in Spring Data JPA
  29. JPA Select latest instance for each item
  30. Spring Data + JPA with multiple datasources but only one set of Repositories

Leave a Comment