Limit the number of results in JPQL

Question

How can I limit the number of results retrieved from the database?

select e from Entity e /* I need only 10 results for instance */ 

Answer 1

You can try like this to get 10 results that will be selected explicitly.

 entityManager.createQuery(JPQL_QUERY) .setParameter(arg0, arg1) .setMaxResults(10) .getResultList(); 

It will automatically create its own query in the background to get a certain amount of results if the backend supports it, and otherwise will make a memory limit after receiving all the results.

Answer 2

You can also set the offset using setFirstResult ()

  em.createNamedQuery("Entity.list") .setFirstResult(startPosition) .setMaxResults(length);