File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

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

You could use a subquery

[How To Ask Questions][Read before you PM me]
I agree. Here's the link:
subject: jpql MAX function help needed
It's not a secret anymore!