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

[b]Hibernate version:[/b]

[b]Mapping documents:[/b]

[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

[b]Name and version of the database you are using:[/b]

[b]The generated SQL (show_sql=true):[/b]

[b]Debug level Hibernate log excerpt:[/b]

Hello Hibernate Users,
I am fairly new to Hibernate and i was wondering if i could get some help with a Hibernate Query.

I have a table called Log which has columns viz. status,synchdate, name, id, updatedon, updatedby.

i want the findByNamedQuery method to return a list such that i get a row for each name whose status was updated most recently.

The name of the object which has these attributes is called entityLog. I want to do something like this:

select entity, max(synchdate) from entityLog where entity in(select distinct(entity) from entityLog) group by entity.

Thanks for all your help in advance.
noobie.