Query from repo (first sql, than field)

Please login or create account to add a snippet.

Follow @TagMyCode

Language: Text

Posted by: Atanaz Talos

Added: May 14, 2020 1:59 PM

Tags: no tags

@Query("SELECT s FROM Student s WHERE s.age = :age and s.name = :name")
public Student findUserByAgeAndNameParams(@Param("age") Integer age,
@Param("name") String name)
@Query(value = "SELECT * FROM pet WHERE owner_human_id > :humanAge", nativeQuery = true)
List<Pet> getPetsWhichOwnerIsOlderThanGivenAge(int humanAge);