<aside> 💡

20.1.2

    @Query("SELECT d FROM Doctor d WHERE d.yearsOfExperience > :experience AND d.department.id = :department")
    List<Doctor> findExperiencedDoctors(@Param("experience") int experience, @Param("departmentId") Long departmentId );

</aside>

JPQL Query :

@Query("SELECT s FROM Student s WHERE s.collegeName = :collegeName ORDER BY s.name DESC")
List<Student> findByCollegeNameOrderByNameDesc(@Param("collegeName") String collegeName);

@Query("SELECT s FROM Student s WHERE s.collegeName = :collegeName AND s.yearOfAdmission = :year ORDER BY s.name DESC")
List<Student> findByCollegeNameAndYearOrderByNameDesc(@Param("collegeName") String collegeName, @Param("year") int year);

Join Query: Combines data from multiple entities based on a relationship.

SELECT p FROM Project p JOIN p.employees e WHERE e.id = :employeeId