Hello!
I've two tables - product and salesItems.
A need to retrieve the 10 most sold items. How can I do that with Hibernate?
I try:
String qry = "select p, sum( Sales.qty ) " +
"from Product p" +
"group by p.partNumber " +
"order by sum( Sales.qty )";[]'s,
Regis
------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
