JPA Query 모음

GroupBy 절

@Query("SELECT A FROM Predict A WHERE A.subjectName = :subjectName GROUP BY A.code")
	ArrayList<Predict> findBySubjectNameAndGroupByCode(@Param("subjectName")String subjectName);

 

AND 포함

@Query("SELECT A.code FROM Predict A WHERE A.subjectName = :subjectName AND A.sentence = :sentence")
	ArrayList<String> findCodesBySubjectNameAndSentence(@Param("subjectName")String subjectName, @Param("sentence")String sentence);