spring data jpa 分页问题
项目中分页使用的JpaSpecificationExecutor接口的
Page<T> findAll(Specification<T> spec, Pageable pageable);
现在有个取最大值的查询
select userId, max(score) from exam where examId='1' group by examId, userId
或者
select exam.* from exam,(select userId, max(score) from exam where examId='1' group by examId, userId) as exam_temp where exam_temp.examId=exam.examId
对于Specification参数,不知道如何实现
Specification<T> specification = new Specification<T>(){
@Override
public Predicate toPredicate(Root root, CriteriaQuery criteriaQuery, CriteriaBuilder criteriaBuilder) {
//这里如何实现
}
});
请技术牛人帮忙解决,如有更好办法请告知。