[REFERENCE] Spring Data JPA useful keywords for methods names

Keyword Sample JPQL snippet And findByLastnameAndFirstname … where x.lastname = ?1 and x.firstname = ?2 Or findByLastnameOrFirstname … where x.lastname = ?1 or x.firstname = ?2 Between findByStartDateBetween … where x.startDate between 1? and ?2 LessThan findByAgeLessThan … where x.age < ?1 GreaterThan findByAgeGreaterThan … where x.age > ?1 After findByStartDateAfter … where x.startDate >…