MAX in EJB-QL

Ranch Hand

Posts: 63

posted 17 years ago

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 17 years ago

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.

What's that smell? I think this tiny ad may have stepped in something.

Thread Boost feature

https://coderanch.com/t/674455/Thread-Boost-feature