aspose file tools
The moose likes Object Relational Mapping and the fly likes jpql MAX function help needed 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 "jpql MAX function help needed" Watch "jpql MAX function help needed" New topic
Author

jpql MAX function help needed

caleb momanyi
Ranch Hand

Joined: Jun 17, 2012
Posts: 43



the query above returns an int which is the price of the magazine.
what i need is to get the whole Entity Magazine.
I'm using Glassfish Server v3.1, Java EE 6 and persistence provider eclipselink
Bill Gorder
Bartender

Joined: Mar 07, 2010
Posts: 1682
    
    7

You could use a subquery



[How To Ask Questions][Read before you PM me]
 
Consider Paul's rocket mass heater.
 
subject: jpql MAX function help needed
 
It's not a secret anymore!