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 The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "jpql MAX function help needed" Watch "jpql MAX function help needed" New topic

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

Joined: Mar 07, 2010
Posts: 1681

You could use a subquery

[How To Ask Questions][Read before you PM me]
wood burning stoves
subject: jpql MAX function help needed