How to get last 5 rows?

Question

I'm trying to get the list of only the last five rows from the table. I've already tried with limit 5 but no luck .

Here is the method

@Transactional
public List<Poll> findAllLimit5() {
    return em.createQuery("select a from Poll a ", Poll.class).getResultList();
}

Any help is much appreciated.

https://docs.oracle.com/javaee/7/api/javax/persistence/Query.html#setMaxResults-int- — JB Nizet, Jun 20 '16 at 17:58
Thanks for the link i tried with **setMaxResults** it worked. — B. Adly, Jun 20 '16 at 18:24
in the select query i added **ORDER BY a.id_poll DESC ** so it will receive the last 5 rows and if I did not added that by default it will receive the first 5. — B. Adly, Jun 22 '16 at 07:02

score 0 · Accepted Answer · answered Jun 27 '16 at 23:59

0

Here is the modified method

@Transactional
public List<Poll> findAllLimit5() {
    return em
            .createQuery("select a from Poll a ORDER BY a.id_poll DESC ",
                    Poll.class).setMaxResults(5).getResultList();

}

answered Jun 27 '16 at 23:59

B. Adly

37
1
6

How to get last 5 rows?

1 Answers1