Select top 1 result using JPA

java, jpa

Solution

Try like this

String sql = "SELECT t FROM table t";
Query query = em.createQuery(sql);
query.setFirstResult(firstPosition);
query.setMaxResults(numberOfRecords);
List result = query.getResultList();

It should work

UPDATE*

You can also try like this

query.setMaxResults(1).getResultList();

Problem

I need to bring from DB only one single result. How can I do that with JPA? ``` Select top 1 * from table ``` I tried "select t from table t" ``` query.setMaxResults(1); query.getSingleResult(); ``` but didn't work. Any other ideas?

Original source