jpaderby
Derby jpa select MAX()
I have a little problem with my query.
Here my table 
And I want this rows
But I only get one row
Here my query :
Query q = em.createQuery("SELECT OBJECT(historic) FROM Historic historic WHERE historic.user.id = :user_id AND historic.enchere.id = historic.enchere.id AND historic.limcoins = (SELECT MAX(historic.limcoins) FROM Historic historic WHERE historic.enchere.id = historic.enchere.id AND historic.state LIKE :state)");
q.setParameter("user_id", user_id);
q.setParameter("state", "none");
List<Historic> list = q.getResultList();
Solution
Okay I found.
Replace the = oprator by IN
historic.limcoins IN (SELECT MAX(historic.limcoins) FROM Historic historic WHERE historic.enchere.id = historic.enchere.id AND historic.state LIKE :state)
- Hibernate StatelessSession.upsert() based on @NaturalId
- When to use EntityManager.find() vs EntityManager.getReference() with JPA
- When I use A JPA Query's getResultList(), are the results detached or managed?
- Convert JPA query.getResultList() to MY Objects
- sql query error Spring Boot Sql Query error
- Spring JPA with docker compose: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' or 'hibernate.dialect'
- Hibernate: Could not deserialize - invalid stream header
- How to log SQL parameters binding in JPA queries with Spring Boot 3?
- SQL Multiple Columns in IN clause to convert to JPA
- How to model a polymorphic relationship in Hibernate 6 for foreign entities with different key types?
- Native query with named parameter fails with "Not all named parameters have been set"
- How to specify a JPA named parameter surrounded by wildcards?
- Named query with input parameter
- Casting Integer to String in JPQL
- Field that is Primary key and part of composite foreign key it is not working in SpringBoot Hibernate
- No default constructor for entity
- JPA or Hibernate to generate a (non primary key) column value, not starting from 1
- What is the right way to use a shared EntityManager in JAX-RS resource
- Spring JPA @Query with LIKE
- Spring - JPA - Hibernate how to use EntityManager
- Is it better to use JpaRepository or EntityManager in a Spring application?
- JPA Stop Executing Code in Transaction if Exception Occurs
- Bypass GeneratedValue in Hibernate (merge data not in db?)
- InvalidDataAccessApiUsageException: No enum constant
- Hibernate JoinColumn referencedColumnName
- Opposite of @Nationalized hibernate annotation
- What lombok annotations are mandatory for a JPA entity
- Difference between FetchType LAZY and EAGER in Java Persistence API?
- How to detect N+1 problems in a Hibernate/JPA application
- PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate