Hi all,

I am having trouble to get this query to work, and wondering if you all more experienced hibernate users can shed some light on this.

Let's say I have a class that holds, say, cvs files and their versions:

public class CvsFile
{
private String fileName;
private int version;
...
}

How do you write a query to return all the CvsFile objects for each file and its maximum version?

For example, if I have

aaa 1
aaa 2
aaa 3
bbb 1
bbb 2

I want to return

aaa 3
bbb 2

Any ideas?

Thanks!

select max(c.version), c from CsvFile c
group by c.version

this will return a list of Object[], just retrieve Object[1] from each result

there must other ways to do it...

take a look at "sql query" for example

Hmm, I actually figured it out:

from CvsFile c
where c.version =
(select max(c2.version)
from CvsFile c2
where c.fileName = c2.fileName)

delpouve's way might be a tad more efficient... :)

and a tad incorrect too... :)

details, details...

have you tried sql "style" query?
it seems to be the easier way to do it

Well, in this case, HQL is actually pretty close to SQL.

can you give what sql is logged with my and your hql query?
this can help us