This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
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


Win a copy of Head First Android this week in the Android forum!
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?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Is this type of group by query possible in JPA ?
 
It's not a secret anymore!