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
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: 1649
    
    7

You could use a subquery



[How To Ask Questions][Read before you PM me]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: jpql MAX function help needed