[Hibernate] select last

Bonjour,

J'aimerais obtenir le dernier enregistrement d'un table. J'essaye

Code:

---

1 2	Query query = session.createQuery("SELECT LAST(id) as last_id from MandatProcessDTO as t where t.mandat.id=" + mandatId);

---

mais hibernate me dit:

undefined alias: LAST [SELECT LAST(id) as last_id from ch.ejpd.mantra.dto.MandatProcessDTO as t where t.mandat.id=10294]

Any idea ?

Merci

Ayant trouvé une solution, la voici:

Code:

---

1 2	Query query = session.createQuery("select max(t) from MandatProcessDTO as t where t.mandat.id=" + mandatId);

---