SELECT rs . * from(select t . *,row_number()over(order by t.APPROVEDTIME desc)as row_num from Employee t)rs其中rs.row_num> = 1而rs.row_num <10 order by rs.row_num
1 回答
0
有关分页的信息应在Query接口上设置,而不是在SQL中
List<Employee> employees = entityManager.createQuery("SELECT emp FROM Employee emp ORDER BY emp.id", Employee.class)
.setMaxResults(10)
.setFirstResult(0)
.getResultList();
1 回答
有关分页的信息应在Query接口上设置,而不是在SQL中