我已经创建了一个自定义查询。
如何使此限制功能在其中起作用?
@Repository
public interface SecurityQuestionRepository extends JpaRepository<SecurityQuestion, Integer>{
@Query("select q from SecurityQuestion q order by q.questionId asc limit 0, 3 ")
public List<SecurityQuestion> findQuestion();
}
当我调用服务并调用公共List<SecurityQuestion> findQuestion()
方法时,limit 0,3
没有起作用。
这是Hibernate日志:
Hibernate: select securityqu0_.question_id as question1_4_, securityqu0_.question_desc as question2_4_ from user_security_question securityqu0_ order by securityqu0_.question_id asc
如何使此限制功能在其中起作用?