MAX in EJB-QL

Ranch Hand

Posts: 63

posted 22 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hello:
Is there anyway to use something like MAX SQL clause in EJB-QL. Like this:

If it is not possible how must I rount this EJB-QL limitation.
Thanks,
[ February 10, 2003: Message edited by: Rafael Afonso ]

================================= Rafael U. C. Afonso <a href="http://www.javafree.com.br" target="_blank" rel="nofollow">www.javafree.com.br</a> ================================= Where is debug? debug is on the table

Volodymyr Shram

Ranch Hand

Posts: 47

posted 22 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Originally posted by Rafael Afonso:

Is there anyway to use something like MAX SQL clause in EJB-QL. Like this:
SELECT MAX(p.price) FROM Product p
If it is not possible how must I rount this EJB-QL limitation.
[ February 10, 2003: Message edited by: Rafael Afonso ]

Look here for my post:
http://forum.java.sun.com/thread.jsp?forum=13&thread=330120
You can not use MAX statement in EJB-QL...
Regards, Volodymyr Shram.