Hi,

I want to know if there are ways to generate hibernate sql for this sample query. using Hibernate Criteria API.


Select * from table t where (t.id.key,t.id.version) in (select t.id.key,max(t.id.version) from table t group by t.id.key)

Thanks
Gunspeed



Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html