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:

Hi,

I need some help in writing queries in hibernate as i am new to it.
I have a table with columns as userID , serialNo, userName
with userID and serialNo as composite primary key.
I need to select the records having the maximum serialNo group by userID, ie, i need to get records with unique userID having the maximum serialNo.

Pls help me in writhing the query,

Thanks in advance.

Sunil.

Hi Sunil

Go thorugh the below code. You can do it using Criteria

List results = session.createCriteria(YourClass.class)
.setProjection( Projections.projectionList()
.add( Projections.max("serialNo ")
.add( Projections.groupProperty("userID"))
.list();

For reference look into the below link

http://www.hibernate.org/hib_docs/v3/re ... projection

Try this Out.