Hello,
I have a problem for generate a criteria query, and even in HQL i don't knwo how to do it.

I have a table Action (#ActionId, ActionDate, ActionGroup), and the associated class ActionVO (AcnId, AdnDate, AcnGroup)

I want to retrieve the last action of each group.
So in sql should be something like:
SELECT A.* from Action A
JOIN (select ActionGroupe, max(ActionDate) as dt_action from Action group by ActionGroupe) B
ON A.ActionGroupe = B.ActionGroupe AND A.ActionDate = B.ActionDate;

Any idea of how to do this in Criteria ?
Thank you very much.

I have looked in the book "Java Persistence with Hibernate" but with my knowledges i'm still not able to find a solution :(

any idea please ?
Is my question not explained fine ?