Query query = em.createQuery("from Person p order by id asc"); List list = query.setMaxResults(max).setFirstResult(index).getResultList();