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 Android Security Essentials Live Lessons 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

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

You could use a subquery

[How To Ask Questions][Read before you PM me]
I agree. Here's the link: http://aspose.com/file-tools
subject: jpql MAX function help needed
Similar Threads
dynamically create attendance sheet in jsp
WA #1.....word association
JPA native Query - Select... where... IN, How to set list of values to setParameter()?
JPA - getSingleResult Error
I can set the max results on a query, but can I find what the total would have been without (Paging)