JPQL Complex One to Many Join Query Result Using Java Persistence API (JPA)

Retrieving Last N Rows with Spring Boot JpaRepository: A Deep Dive

Understanding Custom Sorting Parameters with ORDER BY