retrive data

[madhuchilipi reddy]

i am writing in sql my query is "select max(sid) from Student" this is my query.
how i write same query using HQL

[Paul Sturrock]

Its written pretty much the same as you would in SQL:

select max(object.property) from Object object

However, why do you want the max id? I would normally expect an aggregate function to be used on a numeric property, not the primary key?