aspose file tools*
The moose likes Object Relational Mapping and the fly likes Is this type of group by query possible in JPA ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Is this type of group by query possible in JPA ?" Watch "Is this type of group by query possible in JPA ?" New topic
Author

Is this type of group by query possible in JPA ?

Dave Mark
Greenhorn

Joined: Feb 21, 2004
Posts: 19
Taking the query from this website as an example :is it possible to do something like this ?I've shortened it down everything to a minimum while still showing the result I'm looking for (and yes I know it doesn't work!).

What I have at the moment is something like the following...So is there anyway of getting closer to what I'm after?
Will a projection help me?
Or will I always have to iterate over the result to sort it?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Is this type of group by query possible in JPA ?