Hi All ,

I have an HQL like this :
select po, avg(item.price) from foo.PO po join po.items item group by po

How can I have the po sort by avg(item.price) ?

I tried to found google but can't get the answer of this simple sql question. Please help ....

Thanks.

Perseus

Sorry, something missing.

I tried :
select po, avg(item.price) from foo.PO po join po.items item group by po
order by avg(item.price).

But error message :
General error, message from server: "Invalid use of group function"

Thanks.

Perseus

Try "group by "po.foo, po.bar" and all other properties of "po".

But po has quite many properties. Is there any other simpler method ?

Thanks

No, but you are using projection anyway (a select clause), so why don't you simply select only the properties you really need?

Sorry, I don't quite get what you mean.

I would need the whole object of PO rather than only some properties.

Then, group by all properties. This might be changed in a future, but it's actually a documented FAQ:

http://www.hibernate.org/74.html#A12