Please can someone here help? This is all I need converted from SQL to HQL:

SELECT TOP 1 [fieldName] FROM [tableName] ORDER BY [fieldName] DESC

I have actually tried to figure it out on my own but am getting stuck on how to implement "SELECT TOP" and "DESC" in HQL.

It returns the largest number of a certain field within a table, and this one-line of code is all that stands between me and finishing my project (which I needed to have finished yesterday).

Thank you kindly in advance if someone can help!!

-Dave

Ooops ... the SQL statement for which I need an HQL equivalent is actually this:

SELECT MAX( [fieldName] ) FROM [tableName]

Pray tell, how would I do this in HQL?

try to execute hql like " from [Object] order by [column] desc". and first row will give you the max of your desired column.

Thanks it looks like that will work ... although I just discovered an even easier solution:

select max([column]) from [Object]

Thanks!